--DROP TABLE student ;

CREATE TABLE student
(
Uco numeric(8),
Lastname varchar(50),
Sex varchar(5),
Firstname varchar(50),
Studies varchar(100),
CompletionType varchar(8),
EnrollmentDate timestamp
);

INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (474,'Sianová, Tereza','žena','PřF B-EXB BIMAT [sem 5, roč 3]','zk','2020-09-16');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (500,'Mielarová, Anežka','žena','PřF D-VZP STRB [sem 1, roč 1]','zk','2020-07-31');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (451,'Plechová, Anna','žena','PřF N-EXB BIMAT [sem 3, roč 2]','zk','2020-09-02');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (473,'Továčová, Lenka','žena','PřF B-EXB BIMAT [sem 3, roč 2]','zk','2020-06-17');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (484,'Dubíčková, Zuzana','žena','PřF B-EXB BIMAT [sem 3, roč 2]','zk','2020-09-02');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (600,'Mučerová, Hana','žena','PřF B-MBB EPIDM [sem 1, roč 1]','zk','2020-09-03');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (3933,'Bouša, Petr','muž','PřF D-VZP STRB [sem 6, roč 3]','zk','2020-07-30');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4739,'Jenšíková, Alena','žena','PřF B-EXB BIMAT [sem 5, roč 3]','zk','2020-06-23');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4738,'Senšíková, Kateřina','žena','PřF B-EXB BIMAT [sem 5, roč 3]','zk','2020-06-23');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4844,'Vlčochová, Hana','žena','PřF B-EXB BIMAT [sem 3, roč 2]','zk','2020-06-07');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4691,'Kantůčková, Klára','žena','PřF B-EXB BIMAT [sem 4, roč 2]','zk','2020-07-23');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4742,'Filařová, Františka','žena','PřF B-BCH CHI [sem 5, roč 3]','zk','2020-09-01');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (5739,'Hřibylová, Veronika','žena','PřF B-EXB BIMAT [sem 3, roč 2]','zk','2020-09-02');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4848,'Kernerová, Karolína','žena','PřF B-EXB BIMAT [sem 3, roč 2]','zk','2020-06-30');
INSERT INTO student (Uco, Lastname,Sex,Studies, CompletionType, EnrollmentDate) VALUES (4736,'Ouharová, Anna','žena','PřF B-EXB BIMAT [sem 5, roč 3]','zk','2020-06-24');