odbtools/odbctest/mql/aianswer/307valido.mql

SELECT count(DISTINCT temp01.person_account) AS "retired_count" FROM (SELECT person.account AS "person_account" FROM /univ_demo/person person WHERE person.status in ('退休', '离休', '退休返聘') LIMIT 0, 500000) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
matchcount("retired_count", 1469, 1)
**/
;