2021-05-11

info 表

date result

2005-05-09 win

2005-05-09 lose 

2005-05-09 lose 

2005-05-09 lose 

2005-05-10 win 

2005-05-10 lose 

2005-05-10 lose 

如果要生成下列结果, 该如何写sql语句?

   　　    win lose

2005-05-09  2   2 

2005-05-10  1   2 

最终hql：

select
	date,
	sum(if(result = "win" ,1,0 )) win,
	sum(if(result = "false" ,1,0 ))
from	
	info
where
group by
	date