S3->S5 + exemple

Subiectul 3

2) SELECT `Clasa` FROM `scoala` WHERE `Nume`="Ionescu Dan"

3) SELECT `Nume` FROM `scoala` WHERE `Clasa`=(SELECT `Clasa` FROM `scoala` WHERE `Nume`="Ionescu Dan")

Subiectul 4

2) SELECT * FROM `scoala` WHERE `Varsta`>18

3) SELECT * FROM `scoala` order by `Varsta`DESC

Subiect 5
2) UPDATE `examen` SET `MEDIA`=(`NOTA1`+`NOTA2`)/2 WHERE `NOTA1`>=5 AND `NOTA2`>=5

3) SELECT * FROM `examen` WHERE `MEDIA`>=5 ORDER BY `NUME`ASC

EXERCITIU DE ADMIRATIE
--> Afiseaza toti elevii majori din XIIA
SELECT * FROM  `scoala` WHERE `Clasa`="XIIA" AND `Varsta`>=18

--> Afiseaza elevii din XIIA, respectiv XIIB
SELECT * FROM `scoala` WHERE `Clasa`="XIIA" OR`Clasa`="XIIB"