Databases Reporting with SQL Date and Time Functions Today's Report

Robbie Thomas
Robbie Thomas
31,092 Points

Today's Report challenge

I have the code as this:

SELECT COUNT(*) FROM orders WHERE ordered_on = DATE("now") AND status = 'shipped' AS shipped_today;

However, it's telling me I'm wrong. What am I doing wrong?

1 Answer

Robbie Thomas
Robbie Thomas
31,092 Points

Nevermind, figured it out. Forgot that AS goes after the select. The challenge after that gave me that hint.

Beginner's peril here, heh-heh.

SELECT COUNT(*) AS shipped_today FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");