SECOND MINI PROJECT IN SQL: SQL 30 Day Challenge Day 13
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: 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...
#sql #sqltutorial #sqlforbeginners
