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 Reporting with SQL Date and Time Functions Calculating Dates

Posted by Terri Valentine
Terri Valentine
23,034 Points

SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

This answer along with several other answers doesn't seem to work. Is there a bug here or am I missing some information?

1 Answer

Dave StSomeWhere
Dave StSomeWhere
19,870 Points
Dave StSomeWhere
Dave StSomeWhere
19,870 Points

The challenge is asking for Count the total number of orders that were ordered yesterday and have the status of 'shipped'. Alias it to ordered_yesterday_and_shipped.

Your statement below has 2 errors - 1 - incorrect alias and 2 doesn't compare the DATE("now", "-1 day") to anything. Fix those 2 items and you should pass the challenge (just let me know if you need more info):

SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")
Terri Valentine
Terri Valentine
23,034 Points

I still don't understand the necessary correction for error 2 (doesn't compare the DATE("now", "-1 day") to anything).

Dave StSomeWhere
Dave StSomeWhere
19,870 Points
Dave StSomeWhere
Dave StSomeWhere
19,870 Points

Think about how SQL is deciding whether or not to include a row from the table in the result set, and you've been given the requirement to check 2 values - 1. total number of orders that were ordered yesterday and 2. orders that have the status of 'shipped' - so your where clause handles the status but doesn't handle the date - you did create an expression that properly identifies yesterday but you still need to compare that value to each row - does that help?