Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • Unsubscribed User
    Unsubscribed User
    4,387 Points

    We're in a movie database. There's a reviews table with the columns of id, movie_id, username, rev

    Posted March 22, 2022 3:29pm by Unsubscribed User
    Unsubscribed User
    4,387 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    1 Answer

  • brigitte kock
    brigitte kock
    2,054 Points

    Why: 'your query didn't perform the correct average calculation'? Where is my mistake in the code below?

    Posted November 20, 2020 10:20am by brigitte kock
    brigitte kock
    2,054 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    0 Answers

  • Derek Morse
    Derek Morse
    1,776 Points

    missing a step?

    Posted May 18, 2020 4:15pm by Derek Morse
    Derek Morse
    1,776 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    1 Answer

  • Kawaljeet Singh
    Kawaljeet Singh
    3,820 Points

    AVG

    Posted April 17, 2020 12:42pm by Kawaljeet Singh
    Kawaljeet Singh
    3,820 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    2 Answers

  • taherkhan
    taherkhan
    4,327 Points

    Query regarding calculating average

    Posted March 24, 2019 9:46am by taherkhan
    taherkhan
    4,327 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    1 Answer

  • Takyi Akwah
    PLUS
    Takyi Akwah
    Courses Plus Student 1,049 Points

    AVG Help

    Posted August 30, 2018 8:08pm by Takyi Akwah
    Takyi Akwah
    Courses Plus Student 1,049 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Averaging Values

    1 Answer

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

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

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

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord