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

Development Tools

Martina Carrington
Martina Carrington
15,754 Points
Posted by Martina Carrington
Martina Carrington
15,754 Points

Challenge Task 2 of 4 Select all movies released in the year 2009 and later.

i try SELECT* FROM Movie WHERE year 2009 and 2015 and i also try SELECT * FROM movie WHERE year BETWEEN 2009 and 2015:. i keep getting bummer . i don't know if im something wrong and I've rewatch the video

1 Answer

Gaylen Miller
Gaylen Miller
19,286 Points
Gaylen Miller
Gaylen Miller
19,286 Points

Hi,

If the task is to select all the movies released in 2009 and later, something like "between 2009 and 2015" would work right now in year 2015, but it would not work next year in 2016. You'll want to select all movies that were release on or after 2009 and not have an upper boundary. To put that into a logical statement you want all the movies whose release year is 2009 or greater. So "where year >= 2009".