Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases Reporting with SQL Aggregate and Numeric Functions Calculating the Minimum and Maximum Values

A little Lost what am i missing

SELECT ratings, MAX(rating) AS "star_max", MIN(rating) AS "star_min" FROM reviews ORDER BY ratings;

8 Answers

Steven Parker
Steven Parker
217,533 Points

You're close, but:

  • the table has no "ratings" (plural) field, and the instructions only asked for min and max
  • you won't need ORDER BY
  • you will need a WHERE clause to limit the calculations to just "Star Man" ratings

SELECT rating, WHERE ID = 6 MAX(rating) as "star_max" AND MIN(rating) as "star_min" FROM reviews;

Steven Parker
Steven Parker
217,533 Points

As I mentioned before, the instructions only asked for min and max (not "rating" itself). And a WHERE clause always comes after the FROM clause. And you'll want to test "movie_id" instead of "ID".

SELECT rating FROM reviews WHERE movie_id = 6 MAX as "star_max" AND MIN as "star_min"; i still get an error most like gonna a take a break for a while

Steven Parker
Steven Parker
217,533 Points

The original code you started with had a closer SELECT clause, the min and max functions and aliases were fine but the "ratings" just didn't need to be there.

thanks again

define results please

SELECT rating FROM reviews WHERE ID =6 MAX(rating) AS "star_max", MIN(rating) AS "star_min";

it is still off i seem to be missing somehting i am just not seeing;

Steven Parker
Steven Parker
217,533 Points

The functions and aliases need to be in the SELECT clause (as you had originally). And as I mentioned before, you'll want to test "movie_id" instead of "ID".

SELECT rating FROM reviews WHERE "movie_id" = 6, MAX(rating) AS "star_max", MIN(rating) AS "star_min"

i see what you are saying but i think there is one piece missing.

Steven Parker
Steven Parker
217,533 Points

The functions and aliases still need to be in the SELECT clause (as you had originally), but rating by itself does not. And movie_id should not be in quotes.

SELECT rating FROM reviews WHERE movie_id = 6 MAX(rating) AS "star_max", MIN(rating) AS "star_min";

Steven Parker
Steven Parker
217,533 Points

I think we have a misunderstanding of the terms. To be clear, when I talk about the "SELECT clause", I mean the area after the word SELECT but before FROM.

And "rating" should not be there, but the functions and aliases should (as in your very first example).

SELECT rating FROM reviews, MAX(rating) AS "star_max", MIN(rating) AS "star_min" WHERE movie_id =6; still wrong

got in now thanks i see where i was messing up .. you are really helpful