Return the id, name, and genre of all movies that are romances.
this is all i have
SELECT * FROM movies ORDER BY
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';