Issue with creating a table

Hello guys! I’m having a problem on this project (link bellow)… maybe some of you can help me.

https://www.codecademy.com/journeys/computer-science/paths/cscj-22-databases/tracks/cscj-22-database-basics/modules/wdcp-22-working-with-a-database-bed4c6cd-c2f2-40c1-a505-150eea4f15e9/projects/learn_sql_create_table

I’m having a blank output. Here is my code:

CREATE TABLE friends (

id INTEGER,

name TEXT,

birthday DATE,

);

INSERT INTO friends (id, name, birthday)

VALUES (1, ‘Ororo Munroe’, ‘1994-05-30’);

INSERT INTO friends (id, name, birthday)

VALUES (2, ‘Catarina Couto’, ‘1991-03-29’);

INSERT INTO friends (id, name, birthday)

VALUES (1, ‘Caroline Serra’, ‘1989-01-10’);

SELECT * FROM friends;

Thanks!

A way to debug:
What happens when you do a SELECT * after each time you insert values to the table? Do you get results each time? Where does it break down?

2 Likes

Thanks for your answer @lisalisaj but, still not working. I already test with the SELECT * after every INSERT and I already test putting it only in the end, and I am still having to a blank output.