CREATE TABLE Studenti (nr_mat NUMBER(6), nume VARCHAR(20), grupa VARCHAR(6), medie_admit FLOAT);

SELECT * FROM Studenti;

INSERT INTO Studenti VALUES (898989, 'VladTP', '331CA', 9.89);
INSERT INTO Studenti VALUES (1, 'Gigel Frumosu', '336CA', 7.89);
INSERT INTO Studenti VALUES (2, 'Tudorica', '333CA', 9.89);
INSERT INTO Studenti VALUES (3, 'Stana de Piatra', '331CA', 9.73);
INSERT INTO Studenti VALUES (738393, 'Romeo Fantastik', '335CA', 2.5);
INSERT INTO Studenti VALUES (12345, 'Un Coleg de Camera', '331CB', 4);

SELECT * FROM Studenti;

UPDATE Studenti SET media_admitere = 10 WHERE grupa='331CA';

SELECT * FROM Studenti;

DELETE FROM Studenti WHERE grupa='331CB';

SELECT * FROM Studenti;