Skip to main content

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

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

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

  • 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
  • Fahad Ahsan
    Fahad Ahsan
    2,595 Points

    SELECT JOBS.ROLE, COUNT(1) FROM EMPLOYEES JOIN JOBS ON EMPLOYEES.JOB_ID = JOBS.ID ;

    Posted September 8, 2021 12:18pm by Fahad Ahsan
    Fahad Ahsan
    2,595 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • mihneaburtescu
    mihneaburtescu
    348 Points

    Please can you help me with the answer to understand how it works?

    Posted March 24, 2020 6:13pm by mihneaburtescu
    mihneaburtescu
    348 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • Steve Rogers
    Steve Rogers
    3,285 Points

    trouble

    Posted October 29, 2019 10:29pm by Steve Rogers
    Steve Rogers
    3,285 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • Steve Rogers
    Steve Rogers
    3,285 Points

    Counting issue?

    Posted October 21, 2019 2:24pm by Steve Rogers
    Steve Rogers
    3,285 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • Mishu Jahur
    Mishu Jahur
    5,238 Points

    How can "GROUP BY" act on non-column values?

    Posted January 10, 2019 2:22am by Mishu Jahur
    Mishu Jahur
    5,238 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • Donnie Driskell
    Donnie Driskell
    2,243 Points

    sql reporting by example: Day 2 Review (stuck)

    Posted January 6, 2018 3:46am by Donnie Driskell
    Donnie Driskell
    2,243 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    2 Answers

  • sujal Khatiwada
    PLUS
    sujal Khatiwada
    Courses Plus Student 291 Points

    SQL Practice Problem

    Posted December 15, 2017 5:42am by sujal Khatiwada
    sujal Khatiwada
    Courses Plus Student 291 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • olu adesina
    olu adesina
    23,007 Points

    SQL help! i know the answer but i want to understand why

    Posted December 12, 2017 10:59pm by olu adesina
    olu adesina
    23,007 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • olu adesina
    olu adesina
    23,007 Points

    sql help do i need to use the group by key word

    Posted December 12, 2017 8:57pm by olu adesina
    olu adesina
    23,007 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    1 Answer

  • Rashmi Jha
    Rashmi Jha
    2,842 Points

    Fill in the blanks

    Posted October 22, 2017 9:10am by Rashmi Jha
    Rashmi Jha
    2,842 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Day 2: Review

    2 Answers

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