yAJNyQhA

1CREATE TABLE IF NOT EXISTS `roster` (
2  `student_name` varchar(200) NOT NULL,
3  `gender` varchar(200) NOT NULL,
4  `program` varchar(200) NOT NULL,
5  `credit_hours` int(6) unsigned NOT NULL,
6  `gpa` int(6) unsigned NOT NULL,
7  PRIMARY KEY (`student_name`)
8) DEFAULT CHARSET=utf8;
9INSERT INTO `roster` (`student_name`, `gender`, `program`, `credit_hours`,`gpa`) VALUES
10  ('Alex', 'Male', 'Data_Science', '30', '385'),
11  ('Donald', 'Male', 'Data_Science', '55', '381'),
12  ('Becca', 'Female', 'Computer_Science', '52', '350'),
13  ('Dave', 'Male', 'Computer_Science', '45', '340'),
14  ('Kate', 'Female', 'Computer_Science', '49', '370'),
15  ('Bella', 'Female', 'Electrical_Engineering', '38', '390'),
16  ('Bob', 'Male', 'Electrical_Engineering', '45', '370'),
17  ('Cynthia', 'Female', 'Electrical_Engineering', '30', '383'),
18  ('Linda', 'Female', 'Electrical_Engineering', '17', '395'),
19  ('Martha', 'Female', 'Electrical_Engineering', '34', '393');