The following query shows a simple WHERE clause that selects only rows where RETAIL_PRICE_DVD is less than or equal to 20.00. Notice that the column(s) used to filter rows do not have to be included in the query results. However, in many cases it may be a good idea to include them so you can check your results for correctness.

SELECT MOVIE_GENRE_CODE, MOVIE_TITLE

 FROM MOVIE

 WHERE RETAIL_PRICE_DVD <=>

ORDER BY MOVIE_GENRE_CODE, MOVIE_TITLE;