SELECT room.using_department AS "using_department" INTO /t0 FROM /hxyy/room room LIMIT 0, 20000;


SELECT t0.using_department AS "部门",
 count(*) AS "房间数量", 
 count(t0.using_department) AS "房间数量 空不计数" 
 FROM /t0 t0 GROUP BY t0."using_department" order by "房间数量" desc  LIMIT 0, 10

/**
output()
**/
;