select sum(a.money), t.typeGroup from accounts as a
INNER JOIN types as t ON t.id = a.type
GROUP BY t.typeGroup
SELECT sum(money) FROM `accounts` WHERE date >= (CURDATE()-1) AND date < CURDATE() AND type IN (353,448).
SELECT sum(money) FROM `accounts` WHERE date >= (CURDATE()-1) AND date < CURDATE() AND type IN (458,248)
SELECT sum(money),type FROM `accounts` WHERE date >= (CURDATE()-1) AND date < CURDATE() AND type IN (353,448,458,248).