• Home
  • Free Trial
  • Sign In
  • Plans
  • Tracks
  • 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
  • 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,803 Points

    Need help with this query

    Posted October 27, 2020 4:32am by Lyola Rowe
    Lyola Rowe
    3,803 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.

    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
  • Perks
  • Public Library Access
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2023 Treehouse Island, Inc.