059.mql 323 B

1234567891011121314
  1. select count(aaa.org_id) as lll,aaa.org_id from
  2. (match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) return person.id as "person_id", org.id as "org_id") aaa
  3. group by aaa.org_id having count(distinct aaa.person_id)>=20
  4. select count(id), count(distinct day) from /univ_demo/org
  5. /**
  6. output()
  7. **/
  8. ;