如何在同一个表中与where子句多次使用SQL count()函数

Question

假设我有一个表格:

<表类> 名称 数量日期tbody><<tr>name191104"2022-12-01">name211161"2022-12-02">

这是通过count("expression")实现的。当表达式为真

时，这将计数。

select count(case when terminal_id like '911%'  
then name
end)  as [911like]
,count(case when terminal_id like '111%'  
then name
end)  as [111like]
from table
where created_at between '2022-12-01' and '2022-12-10'

更简化:

select sum(terminal_id like '911%') as 911like,
sum(terminal_id like '111%') as 111like
from my_table
where created_at between '2022-12-01' and '2022-12-10';

https://dbfiddle.uk/PqdCP0Fq