สอบถามการนับจำนวน และแยกประเภทโดยใช้คำสั่ง sql select และ คิวรี่ครั้งเดียวครับ.

SELECT
section,
title,
num
FROM tbl_demo3

SELECT
xxx as section,
xxx as title,
xxx as num
FROM tbl_demo3

SELECT
1 as section,
province as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY province

SELECT
2 as section,
class as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY class

SELECT
3 as section,
color as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY color

SELECT
4 as section,
xxx as title,
COUNT(id) as num
FROM tbl_demo3

SELECT
4 as section,
'total' as title,
COUNT(id) as num
FROM tbl_demo3

SELECT
1 as section,
province as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY province
UNION
SELECT
2 as section,
class as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY class
UNION
SELECT
3 as section,
color as title,
COUNT(id) as num
FROM tbl_demo3
GROUP BY color
UNION
SELECT
4 as section,
'total' as title,
COUNT(id) as num
FROM tbl_demo3