write an SQL statement on SQL server

$10-11 USD

Completed

Posted

over 2 years ago

$10-11 USD

Paid on delivery

I need an SQL query statement that gets the average price of the consecutive buy transactions along with the total # of consecutive buy transactions. Also, I need to get the first selling price of the sell transactions that follows each buy transactions. Fore more clarification, see the attached file.

Database Administration

Project ID: 32213988

About the project

5 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@pratikpatelborsa

Hello, We are expert in SQL optimisation and PL/SQL programs. And we're given excellent results. Thanks for your precious time. Best of all, Pratikkumar Patel

$10 USD in 7 days

4.9

(18 reviews)

3.8

5 freelancers are bidding on average $14 USD for this job

@AbdulBasitAli045

Hello , How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in SQL. I am ready to start your project immediately. I am sure I can satisfy you surely and complete in a short time. Please send your message so that we can discuss about your project.

$10 USD in 2 days

4.7

(83 reviews)

5.2

@ahmedkamran9

I'm a UK based database developer with over 18 years of experience in various databases, including Oracle, SQL Server, PostgreSQL and MySQL. I'm also an Azure certified data engineer with experience in ETL process. I can certainly help you in this query to get the consecutive buy and average price. Regards, Kam

$20 USD in 7 days