Q:

how to select from multiple genres in the same column

I'm building a database for a movie rental business (I know its outdated, its a class project) but I'm having trouble trying to display the movie title, movie year, price description, and price rental fee for all movies of the genre 'Family', 'Comedy', or Drama'. Here's the code I'm attempting (but isn't working). Can anyone tell me what command I need to make it work?
SELECT MOVIE_TITLE, MOVIE_YEAR, PRICE_DESCRIPTION, PRICE_RENTFEE
FROM MOVIE, PRICE 
WHERE MOVIE_GENRE = 'FAMILY', 'COMEDY', 'DRAMA'; 

A:

 WHERE MOVIE_GENRE IN ('FAMILY', 'COMEDY', 'DRAMA'); 

or
 WHERE MOVIE_GENRE = 'FAMILY'
    OR MOVIE_GENRE = 'COMEDY'
    OR MOVIE_GENRE = 'DRAMA'; 

or
 JOIN (
   VALUES 
      ('FAMILY'),
      ('COMEDY'),
      ('DRAMA')
 ) AS T(V) ON T.V = MOVIE_GENRE; 

