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...
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