总值和单项值的计数

Question

我有一个这样的表:

<表类> Id 类型 状态 tbody><<tr>1教练1.02教练真正3客户空4教练假5客户空6教练假7客户空8教练真正9教练1.010客户空

尝试以下大小写表达式与窗口计数的组合:

select id, type, 
case when status in ('1.0','True') then 'Active' else 'Inactive' end as Status,
Count(*) over() TotalCount,
Count(*) over(partition by case when status in ('1.0','True') then 1 end) StatusCount
from t
where type='coach'
order by Id;