p7

SELECT ID, TITLU, AUTOR, PRETUNITAR FROM CARTI_PUBLICATE WHERE AUTOR='Mihai Eminescu' ORDER BY PRETUNITAR

SELECT SUM(PRETUNITAR) AS "Cost total - Donaris" FROM CARTI_PUBLICATE WHERE EDITURA='Donaris'

SELECT COUNT(AUTOR), AUTOR FROM CARTI_PUBLICATE GROUP BY AUTOR

SELECT ID, PRETUNITAR FROM CARTI_PUBLICATE WHERE PRETUNITAR=(SELECT MAX(PRETUNITAR) FROM CARTI_PUBLICATE)

DELETE FROM CARTI_PUBLICATE WHERE