Template:OOKM city country sea, queries

questions

only ancestors (without questions)

MATCH
    (inst:Inst {name: 'Marseille'}) 
    -[:INST]->
    (parent:Class)
    -[:SUB*0..]->
    (ancestor:Class)
RETURN ancestor;

╒═══════════════════════════════════╕
│ancestor                           │
╞═══════════════════════════════════╡
│(:Class {name: "French port city"})│
├───────────────────────────────────┤
│(:Class {name: "port city"})       │
├───────────────────────────────────┤
│(:Class {name: "city"})            │
└───────────────────────────────────┘

MATCH
    (inst:Inst {name: 'Marseille'})
    -[:INST]->
    (parent:Class)
    -[:SUB*0..]->
    (ancestor:Class)
    -[quest:QUEST]-
    (:Class)
RETURN quest.name;

╒═════════════════════════╕
│quest.name               │
╞═════════════════════════╡
│"port city access to sea"│
├─────────────────────────┤
│"city part of country"   │
└─────────────────────────┘

answers

only self and ancestors (without answers)

MATCH
    (inst:Inst {name: 'Marseille'})
    -[:INST*0..1]->
    (selfOrParent)
    -[:SUB*0..]->
    (selfOrAncestor)
RETURN selfOrAncestor;

╒═══════════════════════════════════╕
│selfOrAncestor                     │
╞═══════════════════════════════════╡
│(:Inst {name: "Marseille"})        │
├───────────────────────────────────┤
│(:Class {name: "French port city"})│
├───────────────────────────────────┤
│(:Class {name: "port city"})       │
├───────────────────────────────────┤
│(:Class {name: "city"})            │
└───────────────────────────────────┘

MATCH
    (inst:Inst {name: 'Marseille'})
    -[:INST*0..1]->
    (selfOrParent)
    -[:SUB*0..]->
    (selfOrAncestor)
    -[ans:ANS]-
    (ansInst:Inst)
RETURN ans.quest, ansInst.name;

╒═════════════════════════╤═══════════════╕
│ans.quest                │ansInst.name   │
╞═════════════════════════╪═══════════════╡
│"port city access to sea"│"Mediterranean"│
├─────────────────────────┼───────────────┤
│"city part of country"   │"France"       │
└─────────────────────────┴───────────────┘