*******************************************
************* Test Pondělí **************
***************************************

CREATE DATABASE <databaze>;


CREATE TABLE `fakulta` (
  `id_fakulta` int,
  `Zkratka` varchar(5),
  `Nazev` varchar(60),
  `Počet studentu` int
);

insert into fakulta values ('1', 'ESF', 'Ekonomicka fakulta', '12000');
insert into fakulta values ('2', 'LAW', 'Pravnicka fakulta', '15000');
insert into fakulta values ('3', 'MED', 'Lekarska fakulta', '10000');
insert into fakulta values ('4', 'SCI', 'Prirodovedecka fakulta', '5000');
insert into fakulta values ('5', 'PHIL', 'Filozoficka fakulta', '15000');
insert into fakulta values ('6', 'FI', 'Fakulta informatiky', '15000');
insert into fakulta values ('7', 'PED', 'Pedagogicka fakulta', '17000');
insert into fakulta values ('8', 'FSS', 'Socialni studia', '8000');


CREATE TABLE `studenti` (
  `id` int,
  `jmeno_prijmeni` varchar(80),
  `pohlavi` varchar(1),
  `PLAT` int,
  `narozen` date,
  `mesto` varchar(20),
  `id_fakulta` int
);

insert into studenti values ('1', 'janakratka', 'f', '23500', '1954-12-22', 'Brno', '0');
insert into studenti values ('2', 'Jana Nováková', 'F', '42261', '2016-11-11', 'Brno', '1');
insert into studenti values ('3', 'SOPHIA SANTIAGO', 'F', '20758', '1962-11-16', 'Brno', '8');
insert into studenti values ('4', 'Jarek Benes', 'M', '52483', '2017-06-11', 'Praha', '8');
insert into studenti values ('5', 'Petr Maly', 'M', '10000', '2001-09-23', 'Praha', '8');
insert into studenti values ('6', 'Honza Adamec', 'M', '29990', '1977-07-27', 'Praha', '7');
insert into studenti values ('7', 'Petra Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '6');
insert into studenti values ('8', 'Zuzka Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '7');
insert into studenti values ('9', 'Ivan Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '3');
insert into studenti values ('10', 'Petr Novak', 'M', '27679', '2002-05-20', 'Zlin', '2');
insert into studenti values ('11', 'Jirka Plavec', 'M', '23500', '2017-12-30', 'Opava', '1');
insert into studenti values ('12', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '0');
insert into studenti values ('13', 'Ivan Kurzo', 'M', '10000', '2018-02-22', 'Ostrava', '5');
insert into studenti values ('14', 'Petr Novak', 'M', '21072', '2011-06-15', 'Pardubice', '7');
insert into studenti values ('15', 'Iva Novakova', 'F', '23181', '1994-02-13', 'Brno', '8');
insert into studenti values ('16', 'Ela Nová', 'F', '23500', '1987-12-14', 'Brno', '5');
insert into studenti values ('17', 'Jan Novak', 'M', '49213', '1979-08-19', 'Brno', '2');
insert into studenti values ('18', 'petr novak', 'M', '18638', '1960-11-18', 'Brno', '2');
insert into studenti values ('19', 'Tom Krejza', 'M', '21086', '2017-09-24', 'Brno', '3');
insert into studenti values ('20', 'Ida Krejzova', 'F', '54032', '2017-04-03', 'Brno', '5');
insert into studenti values ('21', 'Pavel Pavel', 'M', '23500', '2014-03-14', 'Brno', '7');
insert into studenti values ('22', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '0');
insert into studenti values ('31', 'Jirka Plavec', 'M', '23500', '2017-12-30', 'Opava', '1');
insert into studenti values ('32', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '0');
insert into studenti values ('33', 'Ivan Kurzo', 'M', '10000', '2018-02-22', 'Ostrava', '5');
insert into studenti values ('34', 'Petr Novak', 'M', '21072', '2011-06-15', 'Pardubice', '7');
insert into studenti values ('35', 'Iva Novakova', 'F', '23181', '1994-02-13', 'Brno', '8');
insert into studenti values ('36', 'Ela Nová', 'F', '23500', '1987-12-14', 'Brno', '5');
insert into studenti values ('37', 'Jan Novak', 'M', '49213', '1979-08-19', 'Brno', '2');
insert into studenti values ('38', 'petr novak', 'M', '18638', '1960-11-18', 'Brno', '2');
insert into studenti values ('39', 'Tom Krejza', 'M', '21086', '2017-09-24', 'Brno', '3');
insert into studenti values ('40', 'Ida Krejzova', 'F', '54032', '2017-04-03', 'Brno', '5');
insert into studenti values ('41', 'Pavel Pavel', 'M', '23500', '2014-03-14', 'Brno', '7');
insert into studenti values ('42', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '0');