Spaces:
Running
Running
File size: 2,619 Bytes
b0747e4 2ec542e d63c9ee b0747e4 d63c9ee |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
input_variables: [schema, question]
output_parser: null
template: |
Task:Generate Cypher statement to query a graph database.
Instructions:
Use only the provided relationship types and properties in the schema.
Do not use any other relationship types or properties that are not provided.
Schema:
{schema}
Note: Do not include any explanations or apologies in your responses.
Do not respond to any questions that might ask anything else than for you to construct a Cypher statement.
Do not include any text except the generated Cypher statement.
Examples:
Find all jobs in the 'Software Engineering' industry that offer remote work options and require 'Python' skills?
MATCH (j:Job)
WHERE j.name CONTAINS 'Software Engineer'
AND j.work_mode = 'Remote'
AND (j)-[:REQUIRES]->(:Skill {{name: "Python"}})
RETURN j AS job
Which companies located in 'San Francisco' are hiring for 'Data Scientist' roles with a 'Master's Degree' requirement?
MATCH (c:Company)-[:LOCATES_IN]->(l:Location {{name: "San Francisco"}})
WHERE (c)-[:RECRUITES]->(j:Job {{name: "Data Scientist"}})
AND (j)-[:REQUIRES]->(e:Education {{name: "Master's Degree"}})
RETURN DISTINCT c.name AS company
What are the most common skills required for 'Product Manager' jobs across different industries?
MATCH (j:Job {{name: "Product Manager"}})-[:REQUIRES]->(s:Skill)
RETURN s.name, count(*) AS skill_count
ORDER BY skill_count DESC
LIMIT 10
Find all jobs that require at least 5 years of experience and a 'Bachelor's Degree' in 'Computer Science':
MATCH (j:Job)-[:REQUIRES]->(e:Education {{name: "Bachelor's Degree", fields: "Computer Science"}})
WHERE (j)-[:REQUIRES]->(we:Work_Exper {{duration: "5 years"}})
RETURN j AS job
Identify companies that are subsidiaries of 'Google' and are recruiting for 'Software Engineer' roles with 'Senior' level.
MATCH (g:Company {{name: "Google"}})<-[:SUBDIARY]-(c:Company)
WHERE (c)-[:RECRUITES]->(j:Job {{name: "Software Engineer"}})
AND (j)-[:AT_LEVEL]->(wl:Work_LV {{name: "Senior"}})
RETURN DISTINCT c.name AS company
Find companies recruiting "Machine Learning" jobs and their corresponding job titles.
MATCH (company: Company)-[:RECRUITES]->(job: Job)
WHERE job.name CONTAINS "Machine Learning"
RETURN company.name as company_name, job.name as job_title
Show job description of Machine Learning job at KMS
MATCH (company:Company)-[:RECRUITS]->(job:Job)-[r]->(node)
WHERE job.name CONTAINS "Machine Learning" AND company.name CONTAINS "KMS"
RETURN job, node
The question is:
{question}
template_format: f-string |