Give me at least 5 templates of natural language query, Cypher query and corresponding triplet.
- entity, attribute and value should be replaced with {entity}, {attribute} and {value} for generalization.
- You can use {value2} or {value3} to make complex query. 
- show corresponding entity, attribute and value as 'sample\_triplet' together.
Example is like:
natural\_query: Find {entity}s where {attribute} starts with '{value}'
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} STARTS WITH '{value}' RETURN n
sample\_triplets: user, user\_id, N
Give me at least 5 templates of natural language query, Cypher query and corresponding triplet.
- entity, attribute and value should be replaced with {entity}, {attribute} and {value} for generalization.
- You can use {value2} or {value3} to make complex query. 
- show corresponding entity, attribute and value as 'sample\_triplet' together.
Example is like:
natural\_query: Find {entity}s where {attribute} starts with '{value}'
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} STARTS WITH '{value}' RETURN n
sample\_triplets: user, user\_id, N
user
1. natural_query: Which {entity}s have {attribute} between '{value}' and '{value2}'?
cypher_query: MATCH (n:{entity}) WHERE n.{attribute} >= '{value}' AND n.{attribute} <= '{value2}' RETURN n
sample_triplets: movie, release_year, 2000, 2010

2. natural_query: What are all the {entity}s that have {attribute} equal to '{value}'?
cypher_query: MATCH (n:{entity}) WHERE n.{attribute} = '{value}' RETURN n
sample_triplets: employee, position, 'Software Engineer'

3. natural_query: Show me {entity}s with {attribute} containing the word '{value}'
cypher_query: MATCH (n:{entity}) WHERE toLower(n.{attribute}) CONTAINS toLower('{value}') RETURN n
sample_triplets: product, description, 'smartphone'

4. natural_query: List all {entity}s with {attribute} greater than '{value}'
cypher_query: MATCH (n:{entity}) WHERE n.{attribute} > '{value}' RETURN n
sample_triplets: student, age, 18

5. natural_query: Get {entity}s that have {attribute} less than or equal to '{value}'
cypher_query: MATCH (n:{entity}) WHERE n.{attribute} <= '{value}' RETURN n
sample_triplets: stock, price, 100
assistant
1. Natural query: Retrieve all books written by authors with last names starting with "Smith"
   Cypher query: MATCH (b:Book)-[:WRITTEN_BY]->(a:Author {lastName: {value} 'Smith*'}) RETURN b, b.title, a.firstName, a.lastName
   Sample triplets: (Book_1, title_1, Author_1, "John Smith")

2. Natural query: List all movies released in the year 2021
   Cypher query: MATCH (m:Movie)-[:RELEASED_IN]->(y:Year {year: 2021}) RETURN m, m.title, y.year
   Sample triplets: (Movie_1, "Tenet", 2021)

3. Natural query: Find all products with a rating greater than or equal to 4.5
   Cypher query: MATCH (p:Product)-[:HAS_RATING]->(r:Rating {rating: {value2} >= 4.5}) RETURN p, p.name, r.rating
   Sample triplets: (Product_1, "Headphones", 4.8)

4. Natural query: Show all users who follow at least one account with the username "tech_news"
   Cypher query: MATCH (u:User)-[:FOLLOWS]->(a:Account)-[:HAS_USERNAME {username: 'tech_news'}] RETURN u, u.username, COUNT(a)
   Sample triplets: (User_1, "johndoe", 1)

5. Complex query: Find all books published by authors who have won at least one award
   Cypher query: MATCH (a:Author)-[:WRITTEN_BOOKS]->(b:Book)-[:PUBLISHED_IN]->(y:Year),
         (a)-[:WON_AWARD]->(aw:Award)
   WHERE y.year >= 2010 AND COUNT(aw) >= 1
   RETURN b, b.title, a.firstName, a.lastName, MIN(aw.year)
   Sample triplets: (Book_1, "The Nightingale", "Kristin Hannah", "Kristin", 2015)

Note: In the complex query, {value2} and {value3} are not used, but you could replace "2010" with {value2} to make it more flexible.
Give me at least 5 templates of natural language query, Cypher query and corresponding triplet.
- entity, attribute and value should be replaced with {entity}, {attribute} and {value} for generalization.
- You can use {value2} or {value3} to make complex query. 
- show corresponding entity, attribute and value as 'sample\_triplet' together.
Example is like:
natural\_query: Find {entity}s where {attribute} starts with '{value}'
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} STARTS WITH '{value}' RETURN n
sample\_triplets: user, user\_id, N
user
1. Natural\_query: Show {entity}s with {attribute} greater than {value}
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} > {value} RETURN n
sample\_triplets: product, price, 100; employee, salary, 50000
2. Natural\_query: What are the {entity}s connected to {value} via {attribute}?
cypher\_query: MATCH (n:{entity})-[:{attribute}]->(m) WHERE m.name = '{value}' RETURN n
sample\_triplets: actor, acts\_in, The Matrix; author, writes, Pride and Prejudice
3. Natural\_query: List {entity}s produced in {value} with a {attribute} greater than {value2}
cypher\_query: MATCH (n:{entity}) WHERE n.produced\_in = '{value}' AND n.{attribute} > {value2} RETURN n
sample\_triplets: movie, produced\_in, USA, released\_year, 2010; book, written\_in, England, publication\_year, 1900
4. Natural\_query: Find {entity}s with {attribute} between {value} and {value2}
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} >= {value} AND n.{attribute} <= {value2} RETURN n
sample\_triplets: employee, age, 30, 40; product, price, 100, 200
5. Natural\_query: {entity}s where {attribute} is not '{value}'
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} <> '{value}' RETURN n
sample\_triplets: movie, genre, Horror; book, language, English
assistant
Give me at least 5 templates of natural language query, Cypher query and corresponding triplet.
- entity, attribute and value should be replaced with {entity}, {attribute} and {value} for generalization.
- You can use {value2} or {value3} to make complex query. 
- show corresponding entity, attribute and value as 'sample\_triplet' together.
Example is like:
natural\_query: Find {entity}s where {attribute} starts with '{value}'
cypher\_query: MATCH (n:{entity}) WHERE n.{attribute} STARTS WITH '{value}' RETURN n
sample\_triplets: user, user\_id, N
user
1. Natural query: Retrieve all books written by authors with last names starting with "Smith"
   Cypher query: MATCH (b:Book)-[:WRITTEN_BY]->(a:Author {lastName: {value} 'Smith*'}) RETURN b, b.title, a.firstName, a.lastName
   Sample triplets: (Book_1, title_1, Author_1, "John Smith")

2. Natural query: List all movies released in the year 2021
   Cypher query: MATCH (m:Movie)-[:RELEASED_IN]->(y:Year {year: 2021}) RETURN m, m.title, y.year
   Sample triplets: (Movie_1, "Tenet", 2021)

3. Natural query: Find all products with a rating greater than or equal to 4.5
   Cypher query: MATCH (p:Product)-[:HAS_RATING]->(r:Rating {rating: {value2} >= 4.5}) RETURN p, p.name, r.rating
   Sample triplets: (Product_1, "Headphones", 4.8)

4. Natural query: Show all users who follow at least one account with the username "tech_news"
   Cypher query: MATCH (u:User)-[:FOLLOWS]->(a:Account)-[:HAS_USERNAME {username: 'tech_news'}] RETURN u, u.username, COUNT(a)
   Sample triplets: (User_1, "johndoe", 1)

5. Complex query: Find all books published by authors who have won at least one award
   Cypher query: MATCH (a:Author)-[:WRITTEN_BOOKS]->(b:Book)-[:PUBLISHED_IN]->(y:Year),
         (a)-[:WON_AWARD]->(aw:Award)
   WHERE y.year >= 2010 AND COUNT(aw) >= 1
   RETURN b, b.title, a.firstName, a.lastName, MIN(aw.year)
   Sample triplets: (Book_1, "The Nightingale", "Kristin Hannah", "Kristin", 2015)

Note: In the complex query, {value2} and {value3} are not used, but you could replace "2010" with {value2} to make it more flexible.
assistant