-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  student_name TEXT NOT NULL,
  subject TEXT NOT NULL,
  marks INTEGER NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'Math',81);
INSERT INTO students VALUES (2, 'Joanna', 'Science',92);
INSERT INTO students VALUES (3, 'Luke', 'History',68);
INSERT INTO students VALUES (4, 'Jess', 'English',86);
INSERT INTO students VALUES (5, 'Matthew', 'Music',72);
-- fetch some values
SELECT * FROM students