17,075
社区成员
发帖
与我相关
我的任务
分享
WITH t AS (
SELECT 'A' mc, '1日' AS rq,'2' AS jg FROM dual
union all
SELECT 'A', '2日' AS STR2,'4' AS STR3 FROM dual
union all
SELECT 'B', '1日','6' FROM dual
union all
SELECT 'B', '2日','8' FROM dual
union all
SELECT 'B', '3日','10' FROM dual
)
SELECT avg(pj)
FROM (SELECT avg(jg) AS pj FROM t GROUP BY mc);
AVG(PJ)
----------
5.5
WITH TABLE1 AS (
SELECT 'A' AS STR1, '1R' AS STR2,'2' AS STR3 FROM dual
union all
SELECT 'A' AS STR1, '2R' AS STR2,'4' AS STR3 FROM dual
union all
SELECT 'B' AS STR1, '1R' AS STR2,'6' AS STR3 FROM dual
union all
SELECT 'B' AS STR1, '2R' AS STR2,'8' AS STR3 FROM dual
union all
SELECT 'B' AS STR1, '3R' AS STR2,'10' AS STR3 FROM dual
)
SELECT SUM(STR3) /COUNT(0) AS STR3 FROM (
SELECT SUM(STR3) /COUNT(0) AS STR3 FROM TABLE1 GROUP BY STR1)
1 5.5