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

PHP Integrating PHP with Databases Querying the Database with PHP Retrieving Data

Posted by Jothum Chitewe
Jothum Chitewe
7,833 Points

SQL SELECT QUERY

hELP

2 Answers

Antonio De Rose
Antonio De Rose
20,886 Points
Antonio De Rose
Antonio De Rose
20,886 Points

what help you needed

this is the question

Write the SQL query to select 'name' and the 'price' from the 'products' table.

take a start, if you aren't able to, go back to the videos, where you may think this video, covers this same type of quiz, make an attempt, and we can help you.

Jothum Chitewe
Jothum Chitewe
7,833 Points

the following code does not pass

SELECT name, price FROM table_products;

Antonio De Rose
Antonio De Rose
20,886 Points
Antonio De Rose
Antonio De Rose
20,886 Points 
SELECT name, price FROM table_products;

/*the above is your answer, nothing wrong with your approach, perfectly correct
however the issue. if you read again the question you will understand
question) Write the SQL query to select 'name' and the 'price' from the 'products' table.
does it ask for a table_products table or a products table*/