8,497
社区成员
发帖
与我相关
我的任务
分享
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 '%北京%';