Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. CREATE TABLE students(
  2. id serial PRIMARY KEY,
  3. name TEXT,
  4. mark INTEGER,
  5. age INTEGER,
  6. subject TEXT
  7. );
  8.  
  9. INSERT INTO students(name, mark, age, subject)
  10. VALUES
  11. ('John', 9, 15, 'Math'),
  12. ('Thomas', 2, 15, 'Math'),
  13. ('Alice', 6, 14, 'Math'),
  14. ('Tom', 9, 13, 'History'),
  15. ('Bob', 9, 13, 'History'),
  16. ('Nancy', 7, 12, 'History'),
  17. ('Will', 7, 17, 'History'),
  18. ('El', 3, 13, 'History'),
  19. ('Jones', 9, 13, 'Biology'),
  20. ('Smith', 8, 13, 'Biology'),
  21. ('Daisy', 8, 13, 'Biology'),
  22. ('Jerry', 8, 13, 'Biology'),
  23. ('Eric', 6, 13, 'Biology'),
  24. ('Logan', 7, 13, 'Biology')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement