I typed in the first part and the project and hit save and it populated the query
Did the 2nd. 3rd 4th…etc… task and nothing
does this look correct
CREATE TABLE Friends (ID integer, Name Text, Birthday Date);
INSERT INTO Friends (ID, Name, Birthday)
VALUES (1, ‘jane doe’, 1993-05-19);
INSERT INTO Friends (ID, Name, Birthday)
VALUES (‘2’,‘Jane Doo’,‘1993-05-19’) VALUES (3,‘Jack Doe’,‘1993-04-19’) VALUES (‘4’,‘JOe Doe’,1992-03-19);
UPDATE Friends
SET Name=‘Jane Doe’
WHERE Name=‘Jane Smith’;
ALTER TABLE Friends
ADD column Email Text;
UPDATE Friends
SET Name=‘Jane Doe’, Name=‘Jane Doo’, Name=‘Jack Doe’, Name=‘Joe Doe’
WHERE Email=‘[email protected]’, Email= ‘[email protected]’, Email=‘[email protected]’, Email= ‘[email protected]’;
DELETE FROM Friends
WHERE Name=‘Jane Doe’;