Why is my table not updating

CREATE TABLE friends (
id INTEGER,
name Text,
birthday DATE,
);
Insert INTO friends (id, name, birthday);
VALUES (1, ‘Jane Doe’,‘1990-05-30’);
INSERT INTO friends (id, name, birthday);
VALUES (2, ‘abraham lincoln’, ‘2019-05-15’);
INSERT INTO friends (id, name, birthday);
VALUES (3, ‘big boy with with big socks’, ‘2001-9-20212’);
UPDATE friends
SET name = ‘Jane Smith’
WHERE id = 1;
SELECT * FROM friends;

it also wont let me update anything other i even copy and paste the code but it wont change anything

Are you sure the table has been created?

After “birthday Date” there shouldn’t be a comma, as this is the last line.

Also, this should just be one line. You shouldn’t have a semicolon after “friends (id, name, birthday)”.