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

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

New No-Code Track! 🚀start learning today!

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

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

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • 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 College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • 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
      • • AI
      • • Android
      • • 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
    • Showing results for:
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session
    • Close
  • Aquoinette Blair
    Aquoinette Blair
    3,539 Points

    MAX/MIN Question

    Posted on Nov 20, 2020 by Aquoinette Blair
    Aquoinette Blair
    3,539 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    2 Answers

  • Freddie Kuhle
    Freddie Kuhle
    8,037 Points

    SQL - How can I add a column from one table to my results from another table?

    Posted on Mar 30, 2020 by Freddie Kuhle
    Freddie Kuhle
    8,037 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    1 Answer

  • Sean Flanagan
    Sean Flanagan
    33,236 Points

    Challenge 3 - Movie Average Rating

    Posted on Mar 22, 2018 by Sean Flanagan
    Sean Flanagan
    33,236 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    2 Answers

  • Krishna Diamesso
    Krishna Diamesso
    33,880 Points

    The sql playground is missing some tables. The only table available is the actors table.

    Posted on Sep 29, 2017 by Krishna Diamesso
    Krishna Diamesso
    33,880 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    3 Answers

  • Jonatan Spahn
    Jonatan Spahn
    6,362 Points

    User Average Rating, a little more advanced using subqueries

    Posted on Mar 29, 2017 by Jonatan Spahn
    Jonatan Spahn
    6,362 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    1 Answer

  • Jonatan Spahn
    Jonatan Spahn
    6,362 Points

    Average of each movie

    Posted on Mar 23, 2017 by Jonatan Spahn
    Jonatan Spahn
    6,362 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    3 Answers

  • Jan Lundeen
    Jan Lundeen
    6,121 Points

    On SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?

    Posted on Mar 21, 2017 by Jan Lundeen
    Jan Lundeen
    6,121 Points
    • Databases
    • Reporting with SQL
    • Aggregate and Numeric Functions
    • Practice Session

    3 Answers

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
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.