| 123456789 |
- 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/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)
- **/
- ;
|
