Databases Reporting with SQL Date and Time Functions Calculating Dates

Looking for help on this challenge?

SELECT COUNT (*) AS ordered_yesterday_and_shipped FROM orders WHERE status = "shipped" AND ordered_on BETWEEN DATE("now") AND ("now", -1);

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,370 Points

Your missing the column ordered_on in your condition

SELECT COUNT(*) AS ordered_yesterday_and_shipped FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", "-1 day");

Appreciated!

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,370 Points

Using between would include items from today. The challenge just wants items from yesterday or date = now -1 day.

Kris, thanks for your comment. I tried that way and am still getting the message of 'wrong count.' SELECT COUNT(*) AS ordered_yesterday_and_shipped FROM orders WHERE status = "shipped" AND DATE("now", "-1 day");

Please provide a little extra help?