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
ammarkhan
Front End Web Development Techdegree Student 21,661 PointsDatabase Foundation quiz
I see some strange question or either i am missing some part of it, like
1.In the "actors" table INSERT a new actor with the name "Michael J. Fox". A. and my code it
insert into actors values ("Micheal J. Fox");
- Write a SELECT statement that retrieves all "movies" with the "year" first and the "title" second. A. In the 2nd question, it doesn't tell in which table,?
Am i missing something or something is strange with the quiz?
3 Answers
Ary de Oliveira
28,298 PointsSQL Database foundations
Challenge Task 1 of 3 Write a SELECT statement that retrieves all "movies" with the "year" first and the "title" second. Type in your command below, then press Enter.
SELECT year, title FROM movies;
Challenge Task 2 of 3 Write a SELECT statement that retrieves only the "title" from the "movies" table. Type in your command below, then press Enter.
SELECT title FROM movies;
Challenge Task 3 of 3 From the actors table select the name column using the long form version of the column name i.e. table name followed by the column name. Type in your command below, then press Enter.
SELECT actors.name FROM actors
Alex Hedley
16,381 PointsWas the movies table not mentioned in the video? It's been a while since I've seen this one but you usually get clues in the question anyway. Did you try movies as the Table name?
Eric Butler
33,512 PointsShould just be: SELECT year, title FROM movies
Jason Anello
Courses Plus Student 94,610 PointsJason Anello
Courses Plus Student 94,610 PointsHi Ammar,
Can you link to the code challenge you're on? You should be able to get more direct help that way.