fsF47y0L

1DROP TABLE IF EXISTS Highschooler;
2DROP TABLE IF EXISTS Friend;
3DROP TABLE IF EXISTS Likes;
4
5CREATE TABLE Highschooler (
6    ID integer NOT NULL PRIMARY KEY,
7    name text,
8    grade integer
9);
10
11CREATE TABLE Friend (
12    ID1 integer NOT NULL,
13    ID2 integer NOT NULL,
14    FOREIGN KEY (ID1) REFERENCES Highschooler (ID),
15    FOREIGN KEY (ID2) REFERENCES Highschooler (ID)
16);
17
18CREATE TABLE Likes (
19    ID1 integer NOT NULL,
20    ID2 integer NOT NULL,
21    FOREIGN KEY (ID1) REFERENCES Highschooler (ID),
22    FOREIGN KEY (ID2) REFERENCES Highschooler (ID)
23);
24
25INSERT INTO Highschooler (ID, name, grade) VALUES
26(200, 'Kolam Martinez', 2),
27(201, 'Sarah Martinez', 2),
28(202, 'Daniel Lewis', 4),
29(203, 'Brittany Harris', 5),
30(204, 'Mike Anderson', 3),
31(205, 'Chris Jackson', 1),
32(206, 'Elizabeth Thomas', 2),
33(207, 'James Cameron', 5),
34(208, 'Ashley White', 4),
35(209, 'Ashley White', 4),
36(210, 'Ashley White', 4);
37
38INSERT INTO Friend (ID1,ID2) VALUES
39(200, 201),
40(201, 200),
41(200, 206),
42(206, 200),
43(201, 202),
44(202, 201),
45(202, 206),
46(206, 202),
47(203, 202),
48(202, 203),
49(203, 208),
50(208, 203),
51(203, 207),
52(207, 203),
53(204, 201),
54(201, 204),
55(205, 203),
56(203, 205),
57(205, 204),
58(204, 205),
59(205, 208),
60(208, 205),
61(206, 208),
62(208, 206),
63(208, 204),
64(204, 208);
65
66INSERT INTO Likes (ID1,ID2) VALUES
67(201, 202),
68(202, 206),
69(208, 200),
70(203, 202),
71(203, 208),
72(203, 207),
73(204, 201),
74(205, 203),
75(205, 204),
76(205, 208),
77(207, 206),
78(208, 204);