114.mql 166 B

123456789101112
  1. SELECT
  2. using_department,count(id) as count
  3. FROM
  4. /hxyy/room where affiliated_building = '行政办公楼'
  5. group by using_department
  6. /**
  7. output()
  8. metainfo()
  9. **/
  10. ;