Practice JOINS in SQL: SQL 30 Day Challenge Day 17

Опубликовано: 03 Июль 2024
на канале: Learning with Jelly
158
7

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