SELECT * FROM `ABONATI` ORDER BY `localitate`, `cod` DESC SELECT COUNT(`cod`) FROM `ABONATI` WHERE `min_cons`>`min_ab` AND `localitate`='Campina' UPDATE `ABONATI` SET `factura`=0.5*`min_ab` + 0.55*(`min_cons`-`min_ab`) WHERE `min_cons`>`min_ab`