Could you please let me know how to implement the result column value in the above picture as the field name of the new table? Please give me some advice, thank you all
我想大声告诉你2017-05-18 10:58:14
select date,sum(case when result='win' then 1 else 0 end) win,sum(case when result='lose' then 1 else 0 end) lose from tbl group by date;