SELECT temp01.teacher_dept AS "师资归属单位", count(DISTINCT temp01.teacher_account) AS "教职工人数" FROM (SELECT person.account AS "teacher_account", person.sz_g AS "teacher_dept" FROM /univ_demo_local/person person WHERE person.status = '在职' AND person.sz_g != '' LIMIT 0, 500000) temp01 GROUP BY temp01."teacher_dept" ORDER BY "教职工人数" DESC LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
count(42)
matchcount("师资归属单位", "行为经济学与社会学学院", 1)
matchcount("教职工人数", 127, 1)
**/
;