记录点点滴滴,MySql小练习一题,发现都快忘记了,回头要温习下数据库了
表:
得到结果:
SQL语句:
select a.name,a.胜,b.负 from
(select name,count(balance) as '胜' from account where balance = '胜' group by name) a
left join (select name,count(balance) as '负' from account where balance = '负' group by name) b
on a.name = b.name
where a.name = b.name;