Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

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

Posted by William Hallam
William Hallam
2,948 Points

Query doesn't seem to work and I cannot figure out why not.

As far as I know, the query SELECT COUNT(*) FROM orders WHERE ordered_on = DATE("now") AND status = "shipped" AS shipped_today; should be producing the correct result. The code is modelled on examples from the previous video relating to the DATE() function, as well as videos on the COUNT() function. If I remove the AS shipped_today alias, the error message changes to say that the wrong amount has been counted. What has gone wrong?

1 Answer

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there, William Hallam! You are super close. However, the alias for the column name should appear in the query immediately after you select it. In this case, you're generating a number which is the COUNT of all rows that match that WHERE clause.

Instead of having AS shipped_today; on the very end, you should have SELECT COUNT(*) AS shipped_today FROM orders and then your WHERE clause.

Hope this helps! :sparkles:

William Hallam
William Hallam
2,948 Points

Amusingly, as soon as I posted the question I spotted the syntax error too. Thank you for your explanation regardless.