MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users (`userid` int, `user_type` VARCHAR(9),`last_order_date` DATE);






INSERT INTO users (`userid`, `user_type`, `last_order_date`) VALUES
  (1, 'A', '2021-11-05'),
  (2, 'B', '2021-11-06'),
  (3, 'B', '2021-11-03'),
  (4, 'C', '2021-12-04'),
  (5, 'C', '2021-11-04'),
  (6, 'C', null);

Records: 6  Duplicates: 0  Warnings: 0


CREATE TABLE orders (`user_id` int, `date` DATE,  `total` FLOAT);
INSERT INTO orders (`user_id`, `date`, `total`) VALUES
  (1, '2021-11-05', 50),
  (2, '2021-11-04', 40),
  (2, '2021-11-06', 60),
  (6, '2021-11-02', 45),
  (3, '2021-11-03', 10),
  (5, '2021-11-04', 15),
  (4, '2021-11-05', 15),
  (4, '2021-11-06', 10),
  (4, '2021-12-04', 10);

Records: 9  Duplicates: 0  Warnings: 0


SELECT DATE_FORMAT(o.date, "%b") as label,
UPPER(u.user_type) as user_type,
COUNT(distinct o.user_id) as data FROM orders o 
JOIN users u ON o.user_id = u.userid 
WHERE DATE_FORMAT(o.date, "%Y") = "2021"
GROUP BY DATE_FORMAT(o.date, "%Y %b"), 
u.user_type HAVING SUM(o.total) > 0 ORDER BY o.date ASC


label
user_type
data


Nov
B
2

Nov
C
3

Nov
A
1

Dec
C
1