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

reporting with sql

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.

3 Answers

Hi, I can't figure this question out, can you help?

Hi David,

I did this one yesterday so it's a good refresher for me.

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

Which I read as "count all the rows from the 'orders' table, where the ordered_on date is today's date , and the status is 'shipped' ".

Hope this helps :)

thank you!