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.
Hozzászólások írásához jelentkezzen be.