MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE users (
  id INT,
  status INT
);

INSERT INTO users VALUES
  (1, 0),
  (2, 2),
  (3, 1),
  (4, 1),
  (5, 2),
  (6, 0),
  (7, 2),
  (8, 1),
  (9, 0),
  (10, 1),
  (11, 2),
  (12, 1);
SELECT 
  SUM(CASE WHEN status = 0 THEN 1 ELSE 0 END) AS active_users,
  SUM(CASE WHEN status = 1 THEN 1 ELSE 0 END) AS inactive_users,
  SUM(CASE WHEN status = 2 THEN 1 ELSE 0 END) AS banned_users
FROM users


active_users
inactive_users
banned_users


3
5
4


SELECT *
FROM users
WHERE status = 0


id
status


1
0

6
0

9
0