复杂sql语句编写

1.成绩表分等级

select count(1) 人数,ss 等级 from
(
select case when score <60 then '不及格'
when score <70 and score >60 then '60-70'
when score <80 and score >70 then '70-80'
when score <90 and score >80 then '80-90'
when score <100 and score >90 then '90-100'
else '100'
end
ss from score
where class_id=1 and course_id=1
) tt group by ss

2.实现下图功能所需要的sql

SELECT city 地区,count(city) 客户数量, sum(case when star='1星' then 1 else 0
end ) 1星数量,sum(case when star='2星' then 1 else 0
end ) 2星数量 FROM lixi GROUP BY city