✨ 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
    • Reporting with SQL
    • Date and Time Functions
    • Today's Report
    • Close
  • Grace BakerWhitcomb
    Grace BakerWhitcomb
    1,296 Points

    Help with query please

    Posted on Feb 28, 2024 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 on Oct 18, 2022 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 on Mar 9, 2021 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 on Oct 27, 2020 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 on Oct 27, 2020 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 on Oct 9, 2020 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 on May 19, 2020 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 on Apr 3, 2020 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 on Sep 7, 2019 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 on Feb 23, 2019 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 on Jan 29, 2019 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 on Dec 17, 2018 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 on Aug 7, 2018 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 on Jul 25, 2018 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 on Feb 18, 2018 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 on Sep 26, 2017 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.

    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.