FAQ: Manipulation - Statements

Frequently Asked Questions SQL FAQ
1

Community%20FAQs%20on%20Codecademy%20Exercises
Community%20FAQs%20on%20Codecademy%20Exercises1000×208 141 KB

This community-built FAQ covers the “Statements” exercise from the lesson “Manipulation”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

Learn SQL

FAQs on the exercise Statements

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

2

I am getting an error that says “The query didn’t return any results. Make sure your statement ends in a semicolon.” for page 3 but my code does have a semicolon at the end. Can anyone help?

My code:
CREATE TABLE table_name (
column_1 data_type,
column_2 data_type,
column_3 data_type
);

3

Isn’t it just asking you to do a SELECT * FROM celebs;?

Unless you’re referring to the create table page where you have to specify the actual table name, column names and data types for each column.

Summary 
CREATE TABLE celebs (
 id INTEGER,
 name TEXT,
 age INTEGER);