This is the assignment questions

BTW I am using Jupyter Notebook. I load the extension, create a table, Store the graph in a table, Return Destinations where Source ID > Destination ID, added a weight column, added a random weight(1-10) to each link, returned the distinct wieghts

%load_ext sql

%sql sqlite:///lab1.db

CREATE TABLE MyGraph (
    source INTEGER,
    destination INTEGER
);


INSERT INTO MyGraph (source, destination) VALUES (5, 11);
INSERT INTO MyGraph (source, destination) VALUES (7, 11);
INSERT INTO MyGraph (source, destination) VALUES (7, 8);
INSERT INTO MyGraph (source, destination) VALUES (3, 8);
INSERT INTO MyGraph (source, destination) VALUES (3, 10);
INSERT INTO MyGraph (source, destination) VALUES (11, 2);
INSERT INTO MyGraph (source, destination) VALUES (11, 9);
INSERT INTO MyGraph (source, destination) VALUES (11, 10);
INSERT INTO MyGraph (source, destination) VALUES (8, 9);

%sql SELECT destination FROM MyGraph WHERE source > destination;


%sql ALTER TABLE MyGraph ADD COLUMN weight INTEGER;


%sql UPDATE MyGraph SET weight = ABS(RANDOM() % 10) + 1;


%sql SELECT DISTINCT weight FROM MyGraph;