Create table Elevi( Clasa number(3), Nume varchar2(10), Medie number(5,2));DROP TABLE ELEVI;INSERT INTO Elevi VALUES(9,'Alina',8.25);INSERT INTO Elevi VALUES(11,'Andrei',4.25);INSERT INTO Elevi VALUES(10,'Popescu',5.60);INSERT INTO Elevi VALUES(10,'Dana',9.83);INSERT INTO Elevi VALUES(12,'Ion',9.08);

Select * from elevi where medie between 9 and 10;

Select Count(nume) "sub5"from Elevi WHERE medie