-- create a table
CREATE TABLE student (
  id INTEGER PRIMARY KEY,
  name VARCHAR(20) NOT NULL,
  major VARCHAR(20) UNIQUE
);
-- insert some values
INSERT INTO student VALUES (1, 'Ryan', 'BIOLOGY');
INSERT INTO student VALUES (2, 'Joanna', 'SOCIAL');
INSERT INTO student VALUES (3, ' ','SOC');
INSERT INTO student VALUES (4, 'Joanna', 'SO');
-- fetch some values
SELECT * FROM student;