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

Rasbin Rijal
PLUS
Rasbin Rijal
Courses Plus Student 10,864 Points
Posted by Rasbin Rijal
Rasbin Rijal
Courses Plus Student 10,864 Points

Is table name missing in the question task1?

Hi There

New to database course. Is table name missing in this question?

Select all movies from year 2003.

SELECT movies FROM ...... WHERE year = 2003;

https://teamtreehouse.com/library/database-foundations/reading-data-from-databases-with-sql/querying-tables

2 Answers

Benjamin Larson
Benjamin Larson
34,055 Points
Benjamin Larson
Benjamin Larson
34,055 Points

Hi Rasbin,

It's assuming that 'movies' is the table, and thus it would be:

SELECT * FROM movies WHERE year=2003;

Admittedly, it's not worded very well to arrive at that conclusion. I also was thinking on a first reading that movies was referring to a column name, not a table name.

Per Karlsson
Per Karlsson
12,683 Points
Per Karlsson
Per Karlsson
12,683 Points

Hi Rasbin,

You want to select all movies from the year 2003.

The * operator is short for everything in a table.

So

SELECT * FROM insert_table_name_here WHERE year = 2003;

Would give you the correct result :)

Good luck!

~Per