Cho em hỏi về query ?
![Avatar](https://images.viblo.asia/avatar/f9933e74-6656-4073-837f-6cbf69666ea4.jpeg)
Vũ A
Đã trả lời Jan 18th, 2022 9:45 a.m.
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 |
+-------+------------------------+
0
Tổ chức
Chưa có tổ chức nào.