各位sql高手,帮忙写个sql:表:xx,xx,地市,故障级别,故障时间,xx,xx,....要求:统计各地市的 故障总数、最大的故障级别 例如:地市|故障总数|最大故障级别
----|--------|------------
....|........|............
....|........|............
....|........|............
....|........|............
----|--------|------------
....|........|............
....|........|............
....|........|............
....|........|............
count(*)故障总数,
max(故障级别)最大故障级别
from tb
group by 地市
from tb
group by 地市
from 表
group by 地市
from 表
group by 地市
count(*)故障总数,
max(故障级别)最大故障级别
from tb
group by 地市
from tb
group by 地市假装写一个