Day 17 we are going to practice joins with 3 questions to get more hands on practice with inner joins, joining two tables in SQL, and joining three tables in SQL. Practice, practice, practice your SQL joins.
Video Questions:
/* Question 1: Retrieve the names of all tracks
along with each track’s genre name */
/* Question 2: Retrieve the names of ALL tracks
from the album “Let There Be Rock” */
/*Question 3: Find the total number of tracks
for each ARTIST (hint need to join 3 tables)*/
-----------------------------------------------------------------
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
#sql #sqltutorial #sqlforbeginners
