select field1,field2,field3,field4... --数据合成 T4 from ( -- 基础数据 select sum/count(case when condition1,condition2) as field1,