write an SQL statement on SQL server
Budget: $10 – $11 USD
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.