- What are the top 50 worst rated movies? The results should include the movie title and rating and be sorted by the worst rating first.
SELECT title, rating FROM movies WHERE rating IS NOT NULL ORDER BY movies.rating ASC LIMIT 50;
- What movies do not have a rating? The results should include just the movie titles in sorted order.
SELECT title FROM movies WHERE rating IS NULL ORDER BY title ASC;