What is the lowest and highest rating star?
select max ( stars ), min ( stars ) from rating
What is the movie id and rating date of the movie with 5 stars?
select mid, ratingdate from rating where stars = 5
Now show me the movie id and rating dates of the movie with 2 stars?
select mid, ratingdate from rating where stars = 2
What is the earliest rating date?
select ratingdate from rating where ratingdate ! = 'NULL' order by ratingdate limit 1
What is the most recent rating date?
select ratingdate from rating order by ratingdate desc limit 1