Getting row counts of different columns in one query in MySQL

Code

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;

Result

amount3
254

amount1
279

amount1	amount3
279	254

More Snippets

Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
Even LIKE can use an index in SQL. It depends on the wildcard.
Doing math in SQL can ignore indices

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8