Databases Reporting with SQL Date and Time Functions Calculating Dates

Ali Ahmadian
Ali Ahmadian
11,474 Points

what im doing wrong?please Help!

I can't quite understand what im doing wrong!can someone help me Please?

Ali Ahmadian
Ali Ahmadian
11,474 Points

SELECT COUNT(*) FROM orders ordered_on = DATE("NOW", "-1 day") AND WHERE status = "shipped" AS ordered_yesterday_and_shipped; sorry don't know why it didn't copy the first time. but yeah, don't understand what I am doing wrong :(

1 Answer

Ali Ahmadian
Ali Ahmadian
11,474 Points

never mind, found the Answer :D SELECT COUNT(*) AS ordered_yesterday_and_shipped FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", "-1 day");