To finish creating the ‘Pop’ playlist, add another query that will select the title of all the songs from the ‘Pop’ artists. It should use IN on a nested subquery that’s based on your previous query.??
SELECT title FROM songs WHERE artist IN ( SELECT name FROM artists WHERE artist LIKE ‘Pop’);
what is the crct ans?
New contributor
Karthik Raja is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.