嘿嘿大家帮我看看哈哈

Question

我这这是有条件查一个ID的统计。 那查所有ID的统计出来可以怎么搞啊

Answer 1

参考下面的方法，还望采纳：
可以删除条件语句 "where PLAYER INDEX = 2964060"

select playerIndex, count(player id) as advertisingUpCount, count(valid status=1 or null) as advertisingValidCount
from t_player_advertising_log_20230131
group by playerIndex;