Vũ A

Có lẽ đây là kết quả bạn mong muốn:

SELECT month, IFNULL(ROUND((active / deactive) * 100, 1), 100) AS 'ratio(active/deactive)'
FROM (SELECT month,
             SUM(IF(status = 1, count, 0)) as active,
             SUM(IF(status = 0, count, 0)) as deactive
      FROM (SELECT MONTH(created_date) month, status, COUNT(*) count
            FROM users
            GROUP BY MONTH(created_date), status) u
      GROUP BY u.month) u1;

Kết quả:

+-------+------------------------+
| month | ratio(active/deactive) |
+-------+------------------------+
|     1 |                   50.0 |
|     2 |                  100.0 |
|     7 |                  100.0 |
|     5 |                  100.0 |
|     6 |                    0.0 |
+-------+------------------------+