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

SELECT SUM(`chelt_curente`)+SUM(`restante`), COUNT(`telefon`) FROM `LOCATARI` WHERE `strada`='8Martie' AND `bloc`='15B'

UPDATE `LOCATARI` SET`restante`=1.05*`restante`