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 Byron Injeeli
.a{fill-rule:evenodd;}techdegree seal-36
Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points

Challenge - "count number of orders with status of shipped and shipped date as today". My result is 149.

I cannot get the result that the system says I should.

Steven Parker
Steven Parker
229,786 Points
Steven Parker
Steven Parker
229,786 Points

To enable diagnosis of your issue, please show the code you submitted and also provide a link to the challenge page.

Antonio De Rose
Antonio De Rose
20,884 Points
Antonio De Rose
Antonio De Rose
20,884 Points

Yes please, just as Steven mentioned, send us the link and code.

1 Answer

Alex Bairakovski
Alex Bairakovski
Courses Plus Student 2,563 Points

SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now") You count all the rows from orders WHERE the status is "shipped" and the order date is Today = ( DATE("now") )

Just change the names if it doesnt fit Im not sure how it should be called Ask if youre not sure whats going on in this query