SQL Famous Interview Question - Year on Year Growth | Lag|

drop table tableA;
create TABLE tableA
(
Tenant varchar(20),
Year INT,
sales float
)
insert into tableA values
('tenant 1',2014,2000.00),
('tenant 1',2015,5000.00),
('tenant 2',2013,1000.00),
('tenant 2',2014,1500.00),
('tenant 2',2015,800.00)
select t.*, ((t.sales-t.last_year_sales)/t.last_year_sales)*100 as YoY from
(
select *,lag(sales,1) over (partition by tenant order by year) as last_year_sales from tableA
) t
Check out my course here: www.geekcoders...
#sqlinterview #sqlinterviewquestionsandanswers #dataengineering

[@mohanprasath1781]

Today I planned to learn the YOY concept, I found your video notification. Thanks

[@GeekCoders]

@@mohanprasath1781 thank you sir

[@nikhilbhardwaj3211]

Bhai , Please help me I am in confusion. My current package in Gurgaon is 12.5 Getting offer of 18+3 from mumbai , should I join

[@GeekCoders]

@@nikhilbhardwaj3211 rent in Mumbai is very high. Look for other job until your notice period end