mysql - How to use sql column value as field name of new table?

Question

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

Answer 1

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;