SQL Interview Question | Monthly Percentage Revenue Difference | Tricky Interview Question

In this video we will solve a tricky SQL Interview Question. Question:- Given a table of purchases by date, calculate the month-over-month percentage change in revenue. The output should include the year-month date (YYYY-MM) and percentage change, rounded to the 2nd decimal point, and sorted from the beginning of the year to the end of the year. The percentage change column will be populated from the 2nd month forward and can be calculated as ((this month's revenue - last month's revenue) / last month's revenue)*100. Data:- https://drive.google.com/file/d/1anf8uI5tmNghO76sqq6d54kcDdYTQp_V/view?usp=drive_link 🔍 Looking for something specific? Check out my curated playlists. ✅Complex SQL Interview Questions https://youtube.com/playlist?list=PLRj6ORzjeGQ6u-Jz--t7PTmXSDxfjJWTa&si=nvtIcMCSfJ6CO1j4 ✅SQL Interview Questions https://youtube.com/playlist?list=PLRj6ORzjeGQ531TsgG_twzlY0796sVq1Z&si=XYHZav9zsrvPt7KW ✅SQL Mastery Interview Prep https://youtube.com/playlist?list=PLRj6ORzjeGQ4MBIHa3eebU40TEtL2Exro&si=PHRpwYZkboyzRrtI ✅Learn SQL Concepts https://youtube.com/playlist?list=PLRj6ORzjeGQ78O-MPcTWJuqaPUon_y2Ng&si=AazoKYf9kCwVFO-w ✅SQL Functions https://youtube.com/playlist?list=PLRj6ORzjeGQ43ut0YIOPYoyr35ez0_9dd&si=WBWxVw-_KGlhhokK Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me! Thanks for watching, and see you in the next video!" 🚀