odbtools/odbctest/mql/bench/univdemo_peron_to_org/14select.mql

select * from /univ_demo/org limit -1
/**
output()
count(519)
**/
;


select * from /univ_demo/person limit -1
/**
output()
count(6669)
**/
;


INSERT INTO /univ_demo/person (class, id, name, day, tags, vtime, account, actual_quit_date, age, birthday, deceased_date, degree_level, degree_level_code, is_last_degree, is_last_degree_code, join_u_date, lx_date, main_dept, nation, nation_code, person_sort, person_sort_code, photo_works, polity, polity_code, quit_date, retire_date, sex, sex_code, staff_from, staff_from_code, staff_type, staff_type_code, status, status_code, subject_first, subject_first_code, subject_second, subject_second_code, sz_g, xw_dept, _group, _owner, person_to_org) 
VALUES ('/univ_demo/person', 'univ_demo_person:BW0001', '肖诚术', '2026-04-08T08:00:00+08:00', null, '2026-04-08T14:42:57.113+08:00', 'BW0001', null, '52', '1974-06-29', null, null, null, null, null, null, null, '保卫处（劳务派遣项目外包）', '汉族', '1', '非事业编', '2', null, null, null, null, null, '女', null, null, null, '项目外包常驻人员', '211', '在职', 'on', null, null, null, null, null, null, null, null, '{"_all":["univ_demo_org:1"]}')
;

match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org)
return person.id as "person_id", org.id as "org_id"
/**
output()
**/
;

select count(aaa.org_id) as count, aaa.org_id from 
(match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) 
return person.id as "person_id", org.id as "org_id") aaa
group by aaa.org_id having count(distinct aaa.person_id)>0
/**
output()
count(1)
match("aaa.org_id","univ_demo_org:1",count,1)
**/
;