You must select a tag to post in this category. Please find the tag relating to the section of the course you are on E.g. loops, learn-compatibility
When you ask a question, don’t forget to include a link to the exercise or project you’re dealing with!
If you want to have the best chances of getting a useful answer quickly, make sure you follow our guidelines about how to ask a good question. That way you’ll be helping everyone – helping people to answer your question and helping others who are stuck to find the question and answer!
https://www.codecademy.com/courses/learn-sql/projects/learn_sql_create_table
I have completed the code according to the instructions given by it doesn’t display the expected outcome. Any feedback you can give me would be welcome.
CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id, name, birthday)
VALUES (1, ‘Ororo Munroe’, ‘1940-05-30’);
SELECT * FROM friends;
INSERT INTO friends (id, name, birthday)
VALUES (2, ‘Inday Malyn’, ‘1975-09-01’);
INSERT INTO friends (id, name, birthday)
VALUES (3, ‘Asawa Ko’, ‘1969-06-09’);
SELECT * FROM friends;
UPDATE friends
SET name = ‘Storm’
WHERE id = 1;
ALTER TABLE friends
ADD COLUMN email TEXT;
SELECT * FROM friends;
UPDATE friends
SET email = ‘[email protected]’
WHERE id = 1;
UPDATE friends
SET email + ‘[email protected]’
WHERE id = 2;
UPDATE friends
SET email = ‘[email protected]’
WHERE id = 3;
SELECT * FROM friends;
DELETE FROM friends
WHERE id = 1;
SELECT * FROM friends;
https://www.codecademy.com/courses/learn-sql/projects/learn_sql_create_table