我做了要给柱状图，我想在下一个图中，表示对这个图的一列数据数据挖掘效果，应该怎么做下一个图的SQL语句大概是这样：with t1 as (select nvl(a.areaname,'其它') as areaname ,count(1) cn from of_alarm_data a group by a.areaname) ,t2 as (select count(1) cn from of_alarm_data )select t1.areaname,t1.cn ,round(t1.cn/t2.cn ,2）rate from t1,t2 order by rate desc ; select nodename,count(1) from of_alarm_data where areaname='中区2#阀组' group by nodename order by count(1) desc ;其中，areaname 就是上一个柱状图的维度名称
