Stevan Lay8,306 Points
What is the correct syntax here?
Calculation returned 14 where the quiz also answered as 14. The question asked for total number ordered yesterday. My syntax: SELECT COUNT(ordered_on) AS shipped_yesterday FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", "-1 day");
Where is the error?
(cannot progress lesson without correct answer)