Welcome to the Treehouse Community
Looking to learn something new?
James Dawson2,770 Points
Min, max functions Task
I am being asked to find the MIN and MAX ratings for Starman. Here is my query:
SELECT MIN(rating) AS star_min, MAX(rating) AS star_max, movie_id FROM reviews WHERE movie_id = 6;
I'm asking for MIN rating with alias and MAX rating with it's personal alias. I'm also listing the movie_id in question with a WHERE keyword and Selecting the movie_id. I'm pulling this from the "reviews" table.
It's not working.
What am I missing?