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

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


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


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:2304",count,1)
**/
;