CREATE TABLE student (
  id   INTEGER PRIMARY KEY,
  name VARCHAR(30),
  gender  VARCHAR(10),
  age INTEGER
);

INSERT INTO student (id,name,gender,age) 
VALUES (1,'Bryan', 'Male',20);
INSERT INTO student (id,name,gender,age) 
VALUES (2, 'Ben', 'Male', 22);
INSERT INTO student (id,name,gender,age) 
VALUES (3,'Lisa', 'Female',24);
INSERT INTO student (id,name,gender,age) 
VALUES (4,'Sarah', 'Female',20);
INSERT INTO student (id,name,gender,age) 
VALUES (5,'Jay', 'Male',20);
INSERT INTO student (id,name,gender,age) 
VALUES (6,'John', 'Male',22);
INSERT INTO student (id,name,gender,age) 
VALUES (7,'Jordan', 'Male',24);
INSERT INTO student (id,name,gender,age) 
VALUES (8,'Rob', 'Male',26);
INSERT INTO student (id,name,gender,age) 
VALUES (9,'Will', 'Male',20);
INSERT INTO student (id,name,gender,age) 
VALUES (10,'Shawn', 'Male',22);
INSERT INTO student (id,name,gender,age) 
VALUES (11,'Taylor', 'Female',24);
INSERT INTO student (id,name,gender,age) 
VALUES (12,'Venus', 'Female',26);
INSERT INTO student (id,name,gender,age) 
VALUES (13,'Vince', 'Male',20);
INSERT INTO student (id,name,gender,age) 
VALUES (14,'Carol', 'Female',22);
INSERT INTO student (id,name,gender,age) 
VALUES (15,'Joana', 'Female',24);
INSERT INTO student (id,name,gender,age) 
VALUES (16,'Dion', 'Male',26);
INSERT INTO student (id,name,gender,age) 
VALUES (17,'Evans', 'Male',20);
INSERT INTO student (id,name,gender,age) 
VALUES (18,'Bart', 'Male',22);
INSERT INTO student (id,name,gender,age) 
VALUES (19,'Jenny', 'Female',24);
INSERT INTO student (id,name,gender,age) 
VALUES (20,'Kristine', 'Female',26);