Manipulation - lesson 5 -- can't press next for the next exercise


#1

The instructions for this lesson are:
1 Add three more celebs to the table. In the code editor type
2 Let's take a closer look at SELECT. Under the INSERT statements type

This is my code:
INSERT INTO celebs (id, name, age) VALUES (2, 'Beyonce Knowles', 33);
SELECT name FROM celebs;

INSERT INTO celebs (id, name, age) VALUES (3, 'Jeremy Lin', 26);
SELECT name FROM celebs;

INSERT INTO celebs (id, name, age) VALUES (4, 'Taylor Swift', 26);
SELECT name FROM celebs;

The system allows me to run and it says saving with a green tick but at the same time it displays a red message saying: "use the select statements to view names" and I doesn't allow me to press next.


#2

I can't reproduce what you are seeing at this moment, but try just having the one SELECT statement at the end instead of one after each INSERT.


#3


#4

ok it's solved! thank you so much!!!


#5

INSERT INTO celebs (id, name, age) VALUES (2, ‘Beyonce Knowles’, 33);
SELECT * FROM celebs;
INSERT INTO celebs (id, name, age) VALUES (3, ‘Jeremy Lin’, 26);
SELECT * FROM celebs;
INSERT INTO celebs (id, name, age) VALUES (4, ‘Taylor Swift’, 26);
SELECT * FROM celebs;
It’s good