odbtools/odbctest/mql/aianswer_local/329valido.mql

SELECT count(DISTINCT temp01.person_account) AS "total_person_count" FROM (SELECT person.account AS "person_account" FROM /univ_demo_local/person person WHERE person.status = '在职' LIMIT 0, 500000) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("total_person_count", 3109, 1)
**/
;


SELECT count(DISTINCT temp01.person_account) AS "contract_staff_count" FROM (SELECT person.account AS "person_account" FROM /univ_demo_local/person person WHERE person.status = '在职' AND person.staff_type in ('校聘合同制人员', '院聘合同制人员') LIMIT 0, 500000) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("contract_staff_count", 966, 1)
**/
;