Views
No views yet
<|im_start|>system
You are a Couchbase SQL++ query expert. Given a database schema and a natural language question, generate a syntactically valid SQL++ query that precisely answers the question.
Rules:
- SELECT only the columns explicitly asked for — nothing more, nothing less
- Use the exact bucket, scope, and collection names provided in the schema
Output Format:
In your answer, please enclose the generated SQL++ query in a code block:<|im_end|>
<|im_start|>user
Bucket Name:
`spider_training_bucket`
Scope Name:
`college_2`
Database Schema:
{"`spider_training_bucket`.`college_2`.`prereq`": {"properties": {"course_id": {"samples": ["362", "544"], "type": "string"}, "prereq_id": {"samples": ["123", "487"], "type": "string"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`time_slot`": {"properties": {"day": {"samples": ["F", "M"], "type": "string"}, "end_hr": {"samples": [8, 9], "type": "number"}, "end_min": {"samples": [30, 45], "type": "number"}, "start_hr": {"samples": [9, 10], "type": "number"}, "start_min": {"samples": [0, 30], "type": "number"}, "time_slot_id": {"samples": ["B", "C"], "type": "string"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`advisor`": {"properties": {"i_id": {"samples": ["42782", "48570"], "type": "string"}, "s_id": {"samples": ["30299", "37653"], "type": "string"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`takes`": {"properties": {"course_id": {"samples": ["192", "599"], "type": "string"}, "grade": {"samples": ["A ", "A-"], "type": "string"}, "id": {"samples": ["18821", "49339"], "type": "string"}, "sec_id": {"samples": ["1", "2"], "type": "string"}, "semester": {"samples": ["Fall", "Spring"], "type": "string"}, "year": {"samples": [2002, 2003], "type": "number"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`student`": {"properties": {"dept_name": {"samples": ["Accounting", "Astronomy"], "type": "string"}, "id": {"samples": ["16453", "22004"], "type": "string"}, "name": {"samples": ["Haigh", "Kanata"], "type": "string"}, "tot_cred": {"samples": [18, 41], "type": "number"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`teaches`": {"properties": {"ID": {"samples": ["36897"], "type": "string"}, "course_id": {"samples": ["793", "927"], "type": "string"}, "id": {"samples": ["3335", "42782"], "type": "string"}, "sec_id": {"samples": ["1", "2"], "type": "string"}, "semester": {"samples": ["Fall", "Spring"], "type": "string"}, "year": {"samples": [2002, 2003], "type": "number"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`section`": {"properties": {"building": {"samples": ["Gates", "Lambeau"], "type": "string"}, "course_id": {"samples": ["400", "401"], "type": "string"}, "room_number": {"samples": ["180", "183"], "type": "string"}, "sec_id": {"samples": ["1", "2"], "type": "string"}, "semester": {"samples": ["Fall", "Spring"], "type": "string"}, "time_slot_id": {"samples": ["A", "C"], "type": "string"}, "year": {"samples": [2003, 2004], "type": "number"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`instructor`": {"properties": {"dept_name": {"samples": ["Athletics", "Comp. Sci."], "type": "string"}, "id": {"samples": ["28400", "34175"], "type": "string"}, "name": {"samples": ["Arias", "Atanassov"], "type": "string"}, "salary": {"samples": [61387.56, 84982.92], "type": "number"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`course`": {"properties": {"course_id": {"samples": ["345", "545"], "type": "string"}, "credits": {"samples": [3, 4], "type": "number"}, "dept_name": {"samples": ["Accounting", "Athletics"], "type": "string"}, "title": {"samples": ["Existentialism", "International Practicum"], "type": "string"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`department`": {"properties": {"budget": {"samples": [276527.61, 573745.09], "type": "number"}, "building": {"samples": ["Brodhead", "Linderman"], "type": "string"}, "dept_name": {"samples": ["Astronomy", "Elec. Eng."], "type": "string"}}, "type": "object"}, "`spider_training_bucket`.`college_2`.`classroom`": {"properties": {"building": {"samples": ["Chandler", "Drown"], "type": "string"}, "capacity": {"samples": [11, 12], "type": "number"}, "room_number": {"samples": ["145", "40"], "type": "string"}}, "type": "object"}}
This schema describes the structure of the data in the specified bucket and scope. It includes information about the collections, fields, and their data types.
Question:
Find the minimum salary for the departments whose average salary is above the average payment of all instructors.
<|im_end|>
<|im_start|>assistant<|im_end|>