Writing queries #21


Return the id, name, and genre of all movies that are romances.

this is all i have :frowning:

SELECT * FROM movies

stuck.. live support is closed. trying to code from 12-4 am , thanks,


here is my solution, seems to return the movies but not the genre list.

SELECT id, name FROM movies WHERE genre = 'romance';


Thank you for the response !


select id, name, genre from movies where genre = 'romance';