✨ 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
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers
    • Close
  • Geovani Mejia
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Geovani Mejia
    Front End Web Development Techdegree Student 7,940 Points

    Question on the GROUP BY keyword

    Posted on Oct 12, 2022 by Geovani Mejia
    .a{fill-rule:evenodd;}techdegree
    Geovani Mejia
    Front End Web Development Techdegree Student 7,940 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    1 Answer

  • Paul Brubaker
    Paul Brubaker
    14,290 Points

    Forgot about HAVING keyword and came up with this monstrosity.

    Posted on Aug 26, 2019 by Paul Brubaker
    Paul Brubaker
    14,290 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    3 Answers

  • kevin hudson
    PLUS
    kevin hudson
    Courses Plus Student 11,987 Points

    No Help needed but want to share Code with mistakes

    Posted on Apr 9, 2019 by kevin hudson
    kevin hudson
    Courses Plus Student 11,987 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    0 Answers

  • seth aruby
    seth aruby
    10,111 Points

    Making query account for unknown PERIODS count

    Posted on Feb 20, 2019 by seth aruby
    seth aruby
    10,111 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    1 Answer

  • lukej
    lukej
    34,222 Points

    The meaning of COUNT(1)?

    Posted on Jul 28, 2018 by lukej
    lukej
    34,222 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    2 Answers

  • Ken Stone
    Ken Stone
    29,703 Points

    Alias the count

    Posted on Jul 22, 2017 by Ken Stone
    Ken Stone
    29,703 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    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.