SQL Trick | Compare Sales This Year Vs Last Year for the Same Month

In this SQL Trick, we use the Windows LAG function and set its Offset to compare the sales for the same month - This Year Vs Last Year

You can check detailed explanation in the below video -
https://www.youtube.com/watch?v=CDGwVXknZXI

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate - https://imp.i384100.net/OR37oQ

Google Advanced Data Analytics Professional Certificate - https://imp.i384100.net/eK1WmQ

Best SQL and Data Analytics Books -

T-SQL Fundamentals (By Itzik Ben-Gan) - https://amzn.to/4koKGdC
Ace the Data Science Interview - https://amzn.to/3D2ne5n

Practice SQL Queries on Your Browser through Interactive Courses -
https://learnsql.com/?ref=otm1ytl

Recommended Laptops
Lenovo IdeaPad Slim3 Gen8
https://lenovo-in.zlvv.net/QjOQ2Y

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Website - http://knowstar.org/
Instagram - https://www.instagram.com/learn.knowstar/
Blog - http://know-star.blogspot.com/
Facebook - https://www.facebook.com/knowstartrainings/
Linkedin - https://www.linkedin.com/company/knowstar-e-learning-solutions/?viewAsMember=true
Email - learn@knowstar.org

Видео SQL Trick | Compare Sales This Year Vs Last Year for the Same Month канала Learn at Knowstar