Writing queries #21


#1

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

this is all i have :frowning:

SELECT * FROM movies
ORDER BY

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


#2

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

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


#3

Thank you for the response !


#4

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