SELECT * FROM `LOCATARI` WHERE `nume_pren` LIKE 'A%' ORDER BY `cod_loc`

SELECT SUM(`chelt_curente`)+SUM(`restante`), COUNT(`telefon`) FROM `LOCATARI` WHERE `strada`='Lopatari' AND `bloc`='5D'

UPDATE `LOCATARI` SET `restante`=1.15*`restante`