David Corrales4,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");
Sean M7,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");