Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE students(
- id serial PRIMARY KEY,
- name TEXT,
- mark INTEGER,
- age INTEGER,
- subject TEXT
- );
- INSERT INTO students(name, mark, age, subject)
- VALUES
- ('John', 9, 15, 'Math'),
- ('Thomas', 2, 15, 'Math'),
- ('Alice', 6, 14, 'Math'),
- ('Tom', 9, 13, 'History'),
- ('Bob', 9, 13, 'History'),
- ('Nancy', 7, 12, 'History'),
- ('Will', 7, 17, 'History'),
- ('El', 3, 13, 'History'),
- ('Jones', 9, 13, 'Biology'),
- ('Smith', 8, 13, 'Biology'),
- ('Daisy', 8, 13, 'Biology'),
- ('Jerry', 8, 13, 'Biology'),
- ('Eric', 6, 13, 'Biology'),
- ('Logan', 7, 13, 'Biology')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement