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.
Hi, I can't figure this question out, can you help?
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 :)