SELECT * FROM `ABONATI` WHERE nume LIKE 'C%' AND `min_ab`>=`min_cons` SELECT SUM(`min_cons`) FROM `ABONATI` UPDATE `ABONATI` SET `factura`=0.5*`min_ab`+0.55*(`min_cons`-`min_ab`)