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

Posted by Anonymous User 2
Anonymous User 2
2,251 Points

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

michelle pierce
michelle pierce
2,625 Points
michelle pierce
michelle pierce
2,625 Points

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! :)

michelle pierce
michelle pierce
2,625 Points

Correction to my previous post!

status needs to equal 'shipped' not 'shipped_today'

Anonymous User 2
Anonymous User 2
2,251 Points
Anonymous User 2
Anonymous User 2
2,251 Points

Thanks Michelle - very confusing wording in the question.

That worked! Thank you for your help.

michelle pierce
michelle pierce
2,625 Points

Awesome!