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


I am not getting the right count with the following code

I am on the date section and I a not getting the right count with the following code:

SELECT COUNT(*) AS "shipped_today" FROM orders WHERE status = DATE("now")

Can you please tell me where I am going wrong?

2 Answers

I was confused with this question as well and I had to try a few different things before I got it.

To get the correct count, the status column needs to equal 'shipped_today' and the ordered_on column needs to equal today's date. (You had the correct syntax for getting today's date.)

I hope that helps without giving away the answer! :)

Correction to my previous post!

status needs to equal 'shipped' not 'shipped_today'

Thanks Michelle - very confusing wording in the question.

That worked! Thank you for your help.