Databases Reporting with SQL Date and Time Functions Today's Report

David Corrales
David Corrales
4,651 Points

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

Challenge Task 1 of 1 In an ecommerce database there's an orders table with the columns id, product_id, user_id, address_id, ordered_on, status and cost.

Count the total number of orders that were ordered today and have the status of 'shipped'. Alias it to shipped_today.

Type in your command below, then press Ctrl-Enter.

Bummer: You're count calculation was wrong. Was expecting the count of 13.

SELECT COUNT(*) AS shipped_today FROM orders WHERE status = "shipped" AND DATE("now");

1 Answer

Sean M
Sean M
7,338 Points

You are very close. You only need to specify from which column do you want DATE("now").

This would be the ordered_on column, where you want to find the orders from today/now.

SELECT COUNT(*) AS shipped_today FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");