select a.street_id,count(1) as num from (select SUBSTRING(area_id, 1,9) as street_id from equipment) as a GROUP BY a.street_id
查询equipment表中area_id字段1到9位的数据，并作为子查询结果根据street_id group_by和统计行数
