想要实现下图的堆积图,用下面的SQL怎么去实现??多谢各位了
122776
1. 根据以下的SQL可以查出医院机构的回转量
select count(id) backNum(回转量), receive_org_name(医院机构) from chss_referral_back where left(receive_date,4)='${year}' and status in ('03', '05') GROUP BY receive_org_name
2. 根据这个SQL可以查出医院易购的转出量
select count(id) backNum(转出量), receive_org_name(医院机构) from chss_referral_back where left(receive_date,4)='${year}' and status in ('03', '05') GROUP BY receive_org_name