Shain Jones1,308 Points
Below is the objective and response, The response gives me an error of "expecting a count of 14" I am unsure what is incorrect after looking over it for sometime. Any help would be great.
Objective: 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 yesterday and have the status of 'shipped'. Alias it to ordered_yesterday_and_shipped.
SELECT COUNT(*) AS ordered_yesterday_and_shipped FROM orders WHERE ordered_on = DATE("now", "-1") AND status = "shipped";