🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • 100 Days of Code
    • Live Sessions
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • 100 Days of Code Live Sessions Code Adventures Discord Forum Success Stories Treehouse Links
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • AI
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
  • Van Nguyen
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • theteamtreehouse
    theteamtreehouse
    3,472 Points

    I don't get why this is wrong

    Posted August 21, 2020 12:24am by theteamtreehouse
    theteamtreehouse
    3,472 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Caleb Newell
    Caleb Newell
    12,562 Points

    SUM()

    Posted April 22, 2020 2:32pm by Caleb Newell
    Caleb Newell
    12,562 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Taylor Han
    Taylor Han
    2,406 Points

    (SQL) Finding the sum

    Posted April 20, 2020 9:23pm by Taylor Han
    Taylor Han
    2,406 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Jerry Lombardo
    Jerry Lombardo
    945 Points

    Getting the Grand Total exercise

    Posted November 1, 2019 9:36pm by Jerry Lombardo
    Jerry Lombardo
    945 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • sofia Heikkila Svensson
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • adam woolf
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Ker Sing Tan
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Shahrukh Siddiqui
    Shahrukh Siddiqui
    2,698 Points

    UNABLE TO WRITE THE QUERY

    Posted March 6, 2019 5:51am by Shahrukh Siddiqui
    Shahrukh Siddiqui
    2,698 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Harris Handoko
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Thomas Wilson
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • David Corrales
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    2 Answers

  • Sonia Cabon
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    3 Answers

  • Richard gt
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Amari Hanes
    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
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

  • Christopher Parke
    Christopher Parke
    21,978 Points

    Movie Ratings Question Confusing

    Posted June 21, 2018 4:15pm by Christopher Parke
    Christopher Parke
    21,978 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    2 Answers

  • Robert Keene
    Robert Keene
    5,332 Points

    movie database

    Posted May 30, 2018 3:12pm by Robert Keene
    Robert Keene
    5,332 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Summing Values

    1 Answer

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2024 Treehouse Island, Inc.