Day 13 is practicing your SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT clauses as well as aggregations in SQL.
Case Study Comment:
/* Identify Most Popular Genres
Within those genres, find albums with the most tracks
--these albums can play for a good length of the party just in case the DJ needs a break
Filter out tracks that are less than
3 minutes long (180,000 ms) -- too short to dance to*/
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetutorial.net/sqlite...
Link to Topic List: docs.google.com/document/d/1f...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoods.etsy.com
Buy me a coffee to show support: buymeacoffee.com/learningwith...
#sql #sqltutorial #sqlforbeginners
26 июн 2024