这个sql怎么写

[goodtoyou]

已知表a：单位，盈利额，亏损额。
要生成视图view，view分别统计出盈利和亏损的企业总数（盈利额>亏损额，此单位为盈利，反之为亏损）

[wzh1215]

select sum(case when 盈利额>亏损额 then 1 else 0 end) as 盈利单位个数，sum(case when 盈利额>亏损额 then 1 else 0 end) as 亏损单位个数 from 表a

[wzh1215]

select sum(case when 盈利额>亏损额 then 1 else 0 end) as 盈利单位个数，sum(case when 盈利额>亏损额 then 1 else 0 end) as 亏损单位个数 from 表a

[wzh1215]

改：
select sum(case when 盈利额>亏损额 then 1 else 0 end) as 盈利单位个数，sum(case when 盈利额<亏损额 then 1 else 0 end) as 亏损单位个数 from 表a

[txlicenhe]

create view viewName
As
Select count(*) as 盈利单位个数,-count(*) as 亏损单位个数 from
表a where 盈利额>亏损额