sql课

select
--拼接第一个列 , ||字符||字符
a.certificate_tree_name||'('||count(a.certificate_tree_name)||')' as "拼接好的数据"
--统计结果
,count(a.certificate_tree_name)

from B_CERTIFICATE_TREE a
--A表为字典表
left join B_CERTIFICATE_TREE b on a.certificate_tree_ID = b.certificate_tree_ID
--B表为人员表

group by a.certificate_tree_name

--Order by 时间
--查询条件:时间 > 2xxx:xx:xx