Window functions allows us to retain row level detail in SQL and do calculations such as running totals. This video shows the difference between window functions and group bys and introduces the row_number sql function to you.
--------------------------------------------------------
Download SQLite Studio Here: https://sqlitestudio.pl/
Download the Chinook Database: https://www.sqlitetutorial.net/sqlite...
Link to Topic List: https://docs.google.com/document/d/1f...
Link to Facebook Support Group: / 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/learningwith...