Need help on this SQL error?

Sorry, I had a typo. It should have been this:

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

Please give a link to the Challenge so we can test our suggestion before sending it back. Without it we don't even know which of the Database courses you are in.

"We're in a movie database. There's a reviews table with the columns of id, movie_id, username, review and rating. The movie "Starman" has the id of 6. Movie ids are found in the movie_id column in the reviews table. Write a query that totals up all ratings in the reviews table. Alias it as starman_total_ratings."

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

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

The error was on starman_total_ratings which you put asstart man_total_ratings

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

SELECT SUM(rating) AS start_man_total_ratings FROM reviews GROUP BY movie_id HAVING movie_id=6;