SELECT * FROM `REVISTE` WHERE `an_aparitie`='2010'

SELECT MAX(`pret`) FROM `REVISTE`

UPDATE `REVISTE` SET`nr_ex`=1.15*`nr_ex` WHERE `cod`='300'