oracle通过分组函数将各个专业中的人数显示出来了还同时显示这个专业男生的人数，并显示所占专业人数百分比

SELECT MAX(a.id)       AS id,
  MAX(a.applicationid) AS applicationid,
  MAX(a.domainid)      AS domainid,
  MAX(a.formid)        AS formid,
  MAX(a.formname)      AS formname,
  MAX(a.created)       AS created,
  MAX(a.author)        AS author,
  c.item_OBJJC item_qy,
  b.item_OBJJC item_yy,
  COUNT(b.item_OBJJC) item_counts,//在当前数据基础上获取不符合联系电话规范的数量
  TO_CHAR(COUNT(
  CASE
    WHEN a.item_VC_CPZLSFYG='2'
    THEN 1
  END))
  ||'('
  ||TO_CHAR(ROUND(COUNT(
  CASE
    WHEN a.item_VC_CPZLSFYG='2'
    THEN 1
  END)*100/ COUNT(b.item_OBJJC),2)
  ||'%)') AS item_shbd,
  TO_CHAR(COUNT(
  CASE
    WHEN NOT REGEXP_LIKE(a.item_VC_LXDH,'[+[:digit:]]{1,2}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]*\d{4}|[+[:digit:]]?[-\.,[:blank:]]*\d{1,2}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]+\d{4}|\d{3}[-\.,[:blank:]]+\d{4}')
    THEN 1
  END))
  ||'('
  ||TO_CHAR(ROUND( COUNT(
  CASE
    WHEN NOT REGEXP_LIKE(a.item_VC_LXDH,'[+[:digit:]]{1,2}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]*\d{4}|[+[:digit:]]?[-\.,[:blank:]]*\d{1,2}[-\.,[:blank:]]*\d{3}[-\.,[:blank:]]+\d{4}|\d{3}[-\.,[:blank:]]+\d{4}')
    THEN 1
  END)*100/ COUNT(b.item_OBJJC),2)
  ||'%)') AS item_dhbl //在当前数据基础上获取符合联系电话不规范所占百分比
FROM tlk_SHJCBBK_E a
INNER JOIN tlk_YY_dic b
ON a.item_VC_JCYYBH=b.item_OBJID
LEFT JOIN tlk_QY_dic c
ON c.item_OBJID=b.item_OBJQY
WHERE 1        =1
GROUP BY b.item_OBJJC,
  c.item_OBJJC
ORDER BY item_qy