Interview Prep Solutions

InterviewPrepSolutions.md

SQL:

SELECT title FROM songs
INNER JOIN artist_songs ON songs.id = artist_songs.song_id
INNER JOIN artists ON artists.id = artist_songs.artist_id;

stretch: The above query reterns multiple rows (The same song repeated for each artist). How would you tell sql to only return 1 row for each song answer: add DISTINCT after SELECT