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

mukul lohia
mukul lohia
985 Points
Posted by mukul lohia
mukul lohia
985 Points

In this code challenge you have an eCommerce database full of tables that you might expect to see in a real database. W

In this code challenge you have an eCommerce database full of tables that you might expect to see in a real database. Write a SQL query to answer the following question. What are all the products in the products table?

2 Answers

Alexander Nikiforov
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points
Alexander Nikiforov
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 Points

All you have to do is to SELECT everything from products table.

Take a look at video once more.

Andrew shows query how to SELECT everything from books table at 1:50.

Do you see now, how to do the same with products ?