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

Mit Sengupta
Mit Sengupta
13,823 Points
Posted by Mit Sengupta
Mit Sengupta
13,823 Points

I don't know what am doing wrong?

Here's the code:

SELECT COUNT(*) ordered_on DATE("now", "-1 days") AS "shipped_yesterday" FROM orders WHERE status = "shipped";

2 Answers

Michael Arends
Michael Arends
27,513 Points

COUNT(*), ordered_on, and the DATE function might need a comma between them. I also don't think that your alias shipped_yesterday needs to be in quotes. Are you able to link what question this is?

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

If I remember this challenge correctly, you only select the count (and alias it). Your other terms will be part of the WHERE clause, combined using AND.