sql:case when

select distinct Date,
sum(case Result when '胜' then 1 else 0 end) as '胜',
sum(case Result when '负' then 1 else 0 end) as '负'
from test
group by date

(case FieldName when 'FieldValue' then 1 else 0 end) as 'NewFieldName'

// 语法
case Result
	when '胜' then 1
	when '负' then 2
	else 0
end

case 
	when Result='胜' then 1
	when Result='负' then 2
	else 0
end