几条SQL记录

//统计奔溃次数

select brand as "品牌",android_version as "版本",phone_model as "型号",count(*) as "崩溃次数" from bugs group by phone_model order by count(*) desc;

//统计特殊奔溃原因的出现次数如（jpush库）

select brand as "品牌",android_version as "版本",phone_model as "型号",count(*) from bugs where stack_trace like '%null%' group by phone_model order by count(*) desc;