Neoites who'd like Atom Editor invites

neoites_wanting_atom.cyp

= Neoites who'd like Atom Editor invites

:neo4j-version: 2.0.0
:author: Chris Leishman
:twitter: @cleishm

//setup
//hide
[source,cypher]
----
CREATE (github:Company {name:'GitHub'})
CREATE (atom:Product {name:'Atom Editor'})
CREATE (github)-[:MAKES]->(atom)
CREATE (neotech:Company {name:'Neo Technology'})
CREATE (neo4j:Product {name: 'Neo4j Graph Database'})
CREATE (neotech)-[:MAKES]->(neo4j)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Chris Leishman', email: 'chris.leishman at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Jacob Hansson', email: 'jake at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Max de Marzi', email: 'max at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Michael Hunger', email: 'michael.hunger at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Anders Nawroth', email: 'anders at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Andrés Taylor', email: 'andres at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Viksit Puri', email: 'viksit.puri at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Julian Simpson', email: 'julian.simpson at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Mark Needham', email: 'mark.needham at neotechnology'})-[:HAS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Andreas Kolleger', email: 'andreas.kolleger at neotechnology'})-[:HAS]->(atom)
----

//hide
[source,cypher]
----
MATCH (n) RETURN n
----
//graph

== Which Neoites would like an Atom invite?
[source,cypher]
----
MATCH (p)-[:WANTS]->(:Product { name:"Atom Editor" })
RETURN p.name AS Name, p.email AS Email
----
//table

==== Setup data
[source,cypher]
----
CREATE (github:Company {name:'GitHub'})
CREATE (atom:Product {name:'Atom Editor'})
CREATE (github)-[:MAKES]->(atom)
CREATE (neotech:Company {name:'Neo Technology'})
CREATE (neo4j:Product {name: 'Neo4j Graph Database'})
CREATE (neotech)-[:MAKES]->(neo4j)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Chris Leishman', email: 'chris.leishman at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Jacob Hansson', email: 'jake at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Max de Marzi', email: 'max at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Michael Hunger', email: 'michael.hunger at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Anders Nawroth', email: 'anders at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Andrés Taylor', email: 'andres at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Viksit Puri', email: 'viksit.puri at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Julian Simpson', email: 'julian.simpson at neotechnology'})-[:WANTS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Mark Needham', email: 'mark.needham at neotechnology'})-[:HAS]->(atom)
CREATE (neotech)<-[:WORKS_FOR]-(:Neoite {name: 'Andreas Kolleger', email: 'andreas.kolleger at neotechnology'})-[:HAS]->(atom)
----