• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Go
      • • HTML
      • • iOS
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
      • • Swift
  • Paul Brubaker
    Paul Brubaker
    5,873 Points

    Forgot about HAVING keyword and came up with this monstrosity.

    Posted August 26, 2019 3:37am by Paul Brubaker
    Paul Brubaker
    5,873 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    3 Answers

  • kevin hudson
    PRO
    kevin hudson
    Pro Student 9,645 Points

    No Help needed but want to share Code with mistakes

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

    0 Answers

  • seth aruby
    seth aruby
    7,621 Points

    Making query account for unknown PERIODS count

    Posted February 20, 2019 7:25pm by seth aruby
    seth aruby
    7,621 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    1 Answer

  • lukej
    lukej
    34,218 Points

    The meaning of COUNT(1)?

    Posted July 28, 2018 12:17pm by lukej
    lukej
    34,218 Points
    • Databases
    • SQL Reporting by Example
    • Day 3: Getting Good at Grouping
    • Busiest Teachers

    2 Answers

  • Ken Stone
    Ken Stone
    21,668 Points

    Alias the count

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

Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world.
Our Company
About Us
Contact Us
Community
Treehouse Stories
Student Perks
Treehouse Blog
Affiliate Program
Careers
Topics
HTML
CSS
Design
JavaScript
Ruby
PHP
iOS
Android
Development Tools
Business
Tracks
Web Design
Web Development
Rails Development
PHP Development
iOS Development
Android Development
Starting a Business
  • Treehouse Blog
  • About Treehouse
  • Privacy Policy
  • Terms & Conditions
  • © 2020 Treehouse Island, Inc.

Sign in

I forgot my password