• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Content Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Paul Brubaker
    Paul Brubaker
    14,263 Points

    Forgot about HAVING keyword and came up with this monstrosity.

    Posted August 26, 2019 3:37am by Paul Brubaker
    Paul Brubaker
    14,263 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,577 Points

    No Help needed but want to share Code with mistakes

    Posted April 9, 2019 3:58pm by kevin hudson
    kevin hudson
    Courses Plus Student 11,577 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    0 Answers

  • seth aruby
    seth aruby
    9,292 Points

    Making query account for unknown PERIODS count

    Posted February 20, 2019 7:25pm by seth aruby
    seth aruby
    9,292 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 July 28, 2018 12:17pm 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,701 Points

    Alias the count

    Posted July 22, 2017 11:56pm by Ken Stone
    Ken Stone
    29,701 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

  • Perks
  • Treehouse for Libraries
  • Treehouse for Teams
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2022 Treehouse Island, Inc.