8,493
社区成员




select a.ID,A.NAME, w.online,w.offline,w.sum2 from schools a
LEFT JOIN
(SELECT school_id,
sum(if (work_status = 1,1,0)) AS online,
sum(if (work_status = 2,1,0)) AS offline,
count( work_status ) AS sum2
FROM devices
GROUP BY school_id) w on a.id = w.school_id
where a.name like '%北京%';