MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users
AS
SELECT 'passenger' AS user_type

Records: 1  Duplicates: 0  Warnings: 0


INSERT INTO users
  (`user_type`)
VALUES
  ('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),
  ('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),
  ('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),
  ('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),('driver'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),('passenger'),
  ('passenger'),('passenger'),('passenger');

Records: 89  Duplicates: 0  Warnings: 0


SELECT user_type, COUNT(*) AS cnt, SUM(COUNT(*)) OVER() AS total
FROM  users
WHERE user_type IN ('driver', 'passenger')
GROUP BY user_type


user_type
cnt
total


passenger
58
90

driver
32
90