@cyril6767

-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); -- fetch some val

CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, subject TEXT NOT NULL, marks TEXT NOT NULL ); INSERT INTO students VALUES (1, 'CYRIL', 'Math','95'); INSERT INTO students VALUES (2, 'JOSHUA', 'SCIENCE','96'); INSERT INTO