MySQL - CVIKO 9

-- Priklad 1:
SELECT *, ROUND((4-priemer)*100) AS body FROM Student WHERE ROUND((4-priemer)*100) >= 200;

SELECT * FROM (SELECT *, ROUND((4-priemer)*100) AS body FROM Student) AS B WHERE body >= 200; -- Ked mam vnoreny select v kauzule FROM musime dat allias.
-- ***************************************
-- Priklad 2:
SELECT * FROM Zapis WHERE predmet = 'MAT1' AND body >= (SELECT body FROM Zapis WHERE predmet = 'MAT1' ORDER BY body DESC LIMIT 1);
-- ***************************************
-- Priklad 3:
SELECT *, (SELECT body FROM Zapis WHERE Zapis.predmet = Predmet.skratka ORDER BY body DESC LIMIT 1) AS maxbody FROM Predmet;
-- ***************************************
-- Priklad 4:
SELECT MIN(priemer), MAX(priemer) FROM Student;

SELECT ROUND(MIN(priemer), 2), ROUND(MAX(priemer), 2) FROM Student;
-- ***************************************
-- Priklad 5:
SELECT * FROM Student WHERE priemer <= (SELECT MIN(priemer) FROM Student);
-- ***************************************
-- Priklad 6:
SELECT AVG(body) FROM Zapis WHERE predmet = 'BEZ';
-- ***************************************
-- Priklad 7:
SELECT *, (SELECT MAX(body) FROM Zapis WHERE Stundet.id = Zapis.studentID) AS maxbody FROM Student;
-- ***************************************
-- Priklad 8:
SELECT AVG(priemer) FROM Student WHERE id IN (SELECT studentID FROM Zapis WHERE predmet = 'DBS');
-- ***************************************