Very good knowledge u have about querying..tks

Thank you so much sir for making videos on daily after watching all your videos im feeling that im improving everyday

You are making awesome vidoes hope u get much more viewerships...

Just one request pls use small cte names and aliases it would be easy for beginners all the best..🙂

Awesome 👍 Request you to please make a detailed video on the stored procedure. I have searched the entire youtube but not getting helpful

hi sir what i did first i create one table min(date), max(date) after that i join the table with sales_info then after i by using lead() function i solved the solution with cte as ( select customername , min(date) as first_date, max(date) as last_date from sales_info group by customername ) select *, ((lead(SalesAmount,1) over(partition by c.customerName order by c.first_date)) - s.SalesAmount )*100/s.SalesAmount as prev_amount from cte c inner join sales_info s on s.date in (c.first_date,c.last_date)