sql sum - not sure why my answer is incorrect

there is no reason use having just read your task again and you will see :)

PS use uppercase next time its so hard read your code in no Standards :)

SELECT SUM(rating) AS starman_total_ratings FROM reviews WHERE movie_id = 6;

thanks!!!

Hi there,

It's pretty much what the message said - it's looking for a where clause. You're using 'having' instead, which is generally used when you need to filter after select, but since you don't here, it's looking for a 'where' before your group by instead. In fact, since you're already going to use the 'where' to filter down to one movie, you don't need to group the results. I think it's probably looking for (separated for readability):

select 
   SUM(rating) as starman_total_ratings 
from reviews 
where movie_id = 6

Basically, your 'having' clause works for filtering and returns the data requested, but the challenge is looking specifically for 'where'. Generally speaking, 'where' can be more efficient (if you don't need to filter after select) because 'where' filters the data before select - you generally just want to use 'having' if you have a particular need to filter the data after your initial select is completed. This is generally in cases where you need to filter after you group the initial results. It won't matter here, but I thought I'd mention it because it can make a difference on a larger data set with a lot of rows.

In this example, with 'where' it will only return rows with an ID of 6, then it will add the ratings up. With having, it will return everything, group by the id, then filter down to only the sum for the specified id. In this case, 'where' gives you the same result without unnecessarily totaling up numbers that aren't needed.

I hope this was helpful!