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 Creating and Modifying Database Tables Creating and Modifying Database Tables Creating a Table

Posted by Kevin Kern
Kevin Kern
1,472 Points

I am able to complete the exercise in SQL playground but not the exercise prompt. Is there a difference?

CREATE TABLE ROCK_COLLECTORS_CLUB ( ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK );

1 Answer

Brandon White
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Brandon White
Full Stack JavaScript Techdegree Graduate 35,771 Points
Brandon White
.a{fill-rule:evenodd;}techdegree seal-36
Brandon White
Full Stack JavaScript Techdegree Graduate 35,771 Points

Hi Kevin,

Nice job with your code.

The reason you're not passing the challenge is because you're creating the wrong table. The challenge asks you to create a 'members' table, but you're creating a 'rock_collectors_club' table. Change the table name from ROCK_COLLECTORS_CLUB to MEMBERS, and you'll be good to go.