Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // 9. Katera zvezna drzava ima člane kongresa v največ komitejih
- MATCH (comittee:Committee)<-[:SERVES_ON]-(legislator:Legislator) WITH legislator, COUNT(DISTINCT (comittee)) AS servesNum WITH max(servesNum) as servesMax MATCH (comittee:Committee)<-[:SERVES_ON]-(legislator:Legislator) WITH legislator, COUNT(DISTINCT(comittee)) AS numOfComittees, servesMax WHERE numOfComittees=servesMax RETURN legislator.state, numOfComittees
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement