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


SELECT 
  DATE_FORMAT(DATE(CONCAT_WS('-', YEAR(CURDATE()), months.mm, '01')), "%b") as label, 
  users.user_type, 
  SUM(
    EXISTS (
     SELECT 1
     FROM orders
     WHERE orders.user_id = users.userid
     AND orders.`date` < DATE(CONCAT_WS('-', YEAR(CURDATE()), months.mm, '01'))
    ) AND NOT EXISTS (
     SELECT 1
     FROM orders
     WHERE orders.user_id = users.userid
     AND orders.`date` BETWEEN DATE(CONCAT_WS('-', YEAR(CURDATE()), months.mm, '01')) AND LAST_DAY(DATE(CONCAT_WS('-', YEAR(CURDATE()), months.mm, '01')))
    )
  ) counts
FROM (
 SELECT '01' mm
 UNION SELECT '02' UNION SELECT '03' UNION SELECT '04' UNION SELECT '05' 
 UNION SELECT '06' UNION SELECT '07' UNION SELECT '08' UNION SELECT '09' 
 UNION SELECT '10' UNION SELECT '11' UNION SELECT '12'
) months
CROSS JOIN users
GROUP BY months.mm, users.user_type


label
user_type
counts


Jan
A
1

Jan
B
2

Jan
C
3

Feb
A
1

Feb
B
2

Feb
C
3

Mar
A
1

Mar
B
2

Mar
C
3

Apr
A
1

Apr
B
2

Apr
C
3

May
A
1

May
B
2

May
C
3

Jun
A
1

Jun
B
2

Jun
C
3

Jul
A
1

Jul
B
2

Jul
C
3

Aug
A
1

Aug
B
2

Aug
C
3

Sep
A
1

Sep
B
2

Sep
C
3

Oct
A
1

Oct
B
2

Oct
C
3

Nov
A
1

Nov
B
2

Nov
C
3

Dec
A
1

Dec
B
2

Dec
C
3

label	user_type	counts
Jan	A	1
Jan	B	2
Jan	C	3
Feb	A	1
Feb	B	2
Feb	C	3
Mar	A	1
Mar	B	2
Mar	C	3
Apr	A	1
Apr	B	2
Apr	C	3
May	A	1
May	B	2
May	C	3
Jun	A	1
Jun	B	2
Jun	C	3
Jul	A	1
Jul	B	2
Jul	C	3
Aug	A	1
Aug	B	2
Aug	C	3
Sep	A	1
Sep	B	2
Sep	C	3
Oct	A	1
Oct	B	2
Oct	C	3
Nov	A	1
Nov	B	2
Nov	C	3
Dec	A	1
Dec	B	2
Dec	C	3

label	user_type	counts
Jan	A	1
Jan	B	2
Jan	C	3
Feb	A	1
Feb	B	2
Feb	C	3
Mar	A	1
Mar	B	2
Mar	C	3
Apr	A	1
Apr	B	2
Apr	C	3
May	A	1
May	B	2
May	C	3
Jun	A	1
Jun	B	2
Jun	C	3
Jul	A	1
Jul	B	2
Jul	C	3
Aug	A	1
Aug	B	2
Aug	C	3
Sep	A	1
Sep	B	2
Sep	C	3
Oct	A	1
Oct	B	2
Oct	C	3
Nov	A	1
Nov	B	2
Nov	C	3
Dec	A	1
Dec	B	2
Dec	C	3

label	user_type	counts
Jan	A	1
Jan	B	2
Jan	C	3
Feb	A	1
Feb	B	2
Feb	C	3
Mar	A	1
Mar	B	2
Mar	C	3
Apr	A	1
Apr	B	2
Apr	C	3
May	A	1
May	B	2
May	C	3
Jun	A	1
Jun	B	2
Jun	C	3
Jul	A	1
Jul	B	2
Jul	C	3
Aug	A	1
Aug	B	2
Aug	C	3
Sep	A	1
Sep	B	2
Sep	C	3
Oct	A	1
Oct	B	2
Oct	C	3
Nov	A	1
Nov	B	2
Nov	C	3
Dec	A	1
Dec	B	2
Dec	C	3