[@kalaivanik8872]

with cte as (select *, (total_sales_revenue-lag(total_sales_revenue,1,0) over(partition by product_id))diff from salesq)
select * from products where product_id = (select product_id from cte group by product_id having min(diff) > 0)

[@rajeshraxz9571]

Your explantion and questions are very good ..
We want this type of interview questions and crack the very easy for interview.

[@DEwithDhairy]

Thanks for your kind word...
Do share the channel it will help in growing this channel.
Thanks.

[@rajeshraxz9571]

@@DEwithDhairy sure definitely

[@mohammadsalik468]

Thanks for the explanation
By the way where are you getting the interview questions?

[@DEwithDhairy]

Thanks
Found on the LinkedIn only