SQL Practice Window Functions and CTES: SQL 30 Day Challenge Day 28

Three practice problems using common table expressions (CTEs) in SQL, window functions, and joins. Save your queries so you can showcase them in a project :) -------------------------------------------------------- Download SQLite Studio Here: https://sqlitestudio.pl/ Download the Chinook Database: https://www.sqlitetutorial.net/sqlite-sample-database/ Link to Topic List: https://docs.google.com/document/d/1fcW2Frq4s-Fgr3OpRZtLxEf4ZXHD7wUQI8OrNM7vBA0/edit?usp=sharing Link to Facebook Support Group: https://www.facebook.com/groups/767988395118964/ Link to my Data Etsy Shop (support me to keep making content): https://jellysgeekygoods.etsy.com Buy me a coffee to show support: https://buymeacoffee.com/learningwithjelly