Learn Inner Joins, Left Joins, and Right Joins in SQL. Remember right joins can be written as left joins. Practice joining tables and look at ERD (entity relationship diagrams) to help you out!
Questions:
/* 1) give a list of customers who
have matching invoices. Return customerID,
InvoiceID, InvoiceDate */
/* 2) return all tracks regardless if they
a part of an album or not return AlbumName,
TrackName*/
/* 3) return a list of all album titles
and the names of the artists */
-----------------------------------------------------------------
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetuto...
Link to Topic List: docs.google.co...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoo...
Buy me a coffee to show support: buymeacoffee.c...
#sql #sqltutorial #sqlforbeginners
1 окт 2024