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 trialWilliam Hallam
2,948 PointsQuery 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
Treehouse TeacherHi 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!
William Hallam
2,948 PointsWilliam Hallam
2,948 PointsAmusingly, as soon as I posted the question I spotted the syntax error too. Thank you for your explanation regardless.