Querying IN subqueries chapter 2
My code gives desired result but wont let me move to next assignment. What am I doing wrong.
SELECT * FROM songs WHERE artist IN (SELECT name FROM artists WHERE genre= "Pop");
My code gives desired result but wont let me move to next assignment. What am I doing wrong.
SELECT * FROM songs WHERE artist IN (SELECT name FROM artists WHERE genre= "Pop");
It is SQL
The instruction is to select the title of all the songs from the 'Pop' artists. This code selects all of the columns, not just the title.
Влезте в услугата, за да оставите коментар.