SELECT COUNT(*) AS amount3 FROM history WHERE status = 3; SELECT COUNT(*) AS amount1 FROM history WHERE status = 1; SELECT SUM(status = 1) AS amount1, SUM(status = 3) AS amount3 FROM history;