Treehouse | Community | Summing Values

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Van Nguyen
3,533 Points
Missing WHERE clause but got wrong SQL statement when go for WHERE clause instead of HAVING ?

Posted November 29, 2020 10:59am by Van Nguyen

Van Nguyen
3,533 Points
1 Answer
theteamtreehouse
3,472 Points
I don't get why this is wrong

Posted August 21, 2020 12:24am by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
Caleb Newell
12,562 Points
SUM()

Posted April 22, 2020 2:32pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Taylor Han
2,406 Points
(SQL) Finding the sum

Posted April 20, 2020 9:23pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
sofia Heikkila Svensson
3,695 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
3,695 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Ker Sing Tan
10,573 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
10,573 Points
1 Answer
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Harris Handoko
3,932 Points
Why is the WHERE clause required here instead of the HAVING clause?

Posted February 1, 2019 2:24am by Harris Handoko

Harris Handoko
3,932 Points
1 Answer
Thomas Wilson
18,741 Points
I keep getting the wrong sum but I don't know what I'm doing wrong.

Posted January 17, 2019 2:53pm by Thomas Wilson

Thomas Wilson
18,741 Points
1 Answer
David Corrales
4,698 Points
Need a little help! What am I missing here?

Posted December 16, 2018 10:46pm by David Corrales

David Corrales
4,698 Points
2 Answers
Sonia Cabon
1,173 Points
bummer: you're missing the where cause

Posted September 24, 2018 9:47am by Sonia Cabon

Sonia Cabon
1,173 Points
3 Answers
PLUS

Richard gt
Courses Plus Student 749 Points
Summing Values

Posted August 1, 2018 5:34pm by Richard gt

Richard gt
Courses Plus Student 749 Points
1 Answer
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
select movie_id, sum(reviews) as starman_total_ratings from reviews where movie_id = 6;

Posted July 18, 2018 1:10pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
1 Answer
Christopher Parke
21,978 Points
Movie Ratings Question Confusing

Posted June 21, 2018 4:15pm by Christopher Parke

Christopher Parke
21,978 Points
2 Answers
Robert Keene
5,332 Points
movie database

Posted May 30, 2018 3:12pm by Robert Keene

Robert Keene
5,332 Points
1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Van Nguyen

Van Nguyen

theteamtreehouse

theteamtreehouse

Caleb Newell

Caleb Newell

Taylor Han

Taylor Han

Jerry Lombardo

Jerry Lombardo

sofia Heikkila Svensson

sofia Heikkila Svensson

adam woolf

adam woolf

Ker Sing Tan

Ker Sing Tan

Shahrukh Siddiqui

Shahrukh Siddiqui

Harris Handoko

Harris Handoko

Thomas Wilson

Thomas Wilson

David Corrales

David Corrales

Sonia Cabon

Sonia Cabon

Richard gt

Richard gt

Amari Hanes

Amari Hanes

Christopher Parke

Christopher Parke

Robert Keene

Robert Keene