CREATE TABLE student 
(
meno_krstne VARCHAR(20) NOT NULL, 
meno_priezvisko VARCHAR(20) NOT NULL, 
datum_narodenia DATE NOT NULL,
pohlavie ENUM('M', 'Z') NOT NULL,
student_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
);


INSERT INTO student VALUES ( 'Janko', 'Hraško', '1989-7-3', 'M', '');

INSERT INTO student (meno_krstne, meno_priezvisko, datum_narodenia, pohlavie) VALUES ( 'Jurko', 'Hraško', '1989-8-4', 'M');

INSERT INTO student SET meno_krstne='Anička', meno_priezvisko='Študentka', datum_narodenia='1988-12-6', pohlavie='Z';
INSERT INTO student SET meno_krstne='Martina', meno_priezvisko='Spolužiačka', datum_narodenia='1988-11-3', pohlavie='Z';



SELECT * FROM student;

SELECT * FROM student WHERE pohlavie='M';

SELECT meno_krstne FROM student;

SELECT * FROM student WHERE datum_narodenia>='1989-1-1';

SELECT * FROM student WHERE MONTH(datum_narodenia)='7';

SELECT * FROM student WHERE MONTH(datum_narodenia)=MONTH(CURDATE()) AND 
DAYOFMONTH(datum_narodenia)=DAYOFMONTH(CURDATE()) ;


SELECT * FROM student WHERE meno_priezvisko='Hraško';
SELECT * FROM student WHERE meno_priezvisko LIKE 'H%';

SELECT * FROM student ORDER BY datum_narodenia;

SELECT COUNT(*) FROM student;