Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

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

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

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

  • 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
  • Grace BakerWhitcomb
    Grace BakerWhitcomb
    1,296 Points

    Help with query please

    Posted February 28, 2024 4:50am by Grace BakerWhitcomb
    Grace BakerWhitcomb
    1,296 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    2 Answers

  • Spencer Lebel
    Spencer Lebel
    3,125 Points

    Need helping finding the Count of ordered_on today.

    Posted October 18, 2022 10:44pm by Spencer Lebel
    Spencer Lebel
    3,125 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Anastasia Lynn-Smith
    Anastasia Lynn-Smith
    1,773 Points

    Date challenge - what am I doing wrong?

    Posted March 9, 2021 12:21pm by Anastasia Lynn-Smith
    Anastasia Lynn-Smith
    1,773 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    2 Answers

  • William Hallam
    William Hallam
    2,948 Points

    Query doesn't seem to work and I cannot figure out why not.

    Posted October 27, 2020 11:22am by William Hallam
    William Hallam
    2,948 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Lyola Rowe
    Lyola Rowe
    3,806 Points

    Need help with this query

    Posted October 27, 2020 4:32am by Lyola Rowe
    Lyola Rowe
    3,806 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    2 Answers

  • Talon Ward
    Talon Ward
    2,495 Points

    Am I using the count function correctly here?

    Posted October 9, 2020 4:52am by Talon Ward
    Talon Ward
    2,495 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Caleb Newell
    Caleb Newell
    12,562 Points

    Help with sql date

    Posted May 19, 2020 12:16pm by Caleb Newell
    Caleb Newell
    12,562 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • walter fernandez
    walter fernandez
    4,992 Points

    can some one please give me the solution?

    Posted April 3, 2020 10:40pm by walter fernandez
    walter fernandez
    4,992 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Omar Nousseir
    Omar Nousseir
    2,262 Points

    What is wrong with this SQL query ? SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");

    Posted September 7, 2019 11:33pm by Omar Nousseir
    Omar Nousseir
    2,262 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Namazbek Bekarysuly
    Namazbek Bekarysuly
    882 Points

    What is wrong?

    Posted February 23, 2019 4:03pm by Namazbek Bekarysuly
    Namazbek Bekarysuly
    882 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Michael Nanni
    Michael Nanni
    7,358 Points

    What exactly am I counting?

    Posted January 29, 2019 1:29pm by Michael Nanni
    Michael Nanni
    7,358 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • David Corrales
    David Corrales
    4,698 Points

    Hi Community! Sorry to be a bother! =[ This challenge is stumping me!

    Posted December 17, 2018 12:38am by David Corrales
    David Corrales
    4,698 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Robbie Thomas
    Robbie Thomas
    31,093 Points

    Today's Report challenge

    Posted August 7, 2018 3:32pm by Robbie Thomas
    Robbie Thomas
    31,093 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • david vo
    david vo
    3,278 Points

    reporting with sql

    Posted July 25, 2018 9:37pm by david vo
    david vo
    3,278 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    3 Answers

  • Juan Emmanuel Afable
    Juan Emmanuel Afable
    18,531 Points

    I recommend changing the question to say: "count the total number of orders that was shipped and was ordered today.

    Posted February 18, 2018 10:15pm by Juan Emmanuel Afable
    Juan Emmanuel Afable
    18,531 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

  • Kevin Haller
    Kevin Haller
    5,940 Points

    Mistake in task definition. The query wants to find out all orders, which were shipped today.

    Posted September 26, 2017 9:32am by Kevin Haller
    Kevin Haller
    5,940 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report

    1 Answer

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