Downloads · 30 days
4
5% of all-time downloads
jastorj/couchmind-v5.7.6.1_qwen_stage_2-cw-12K-16bit
couchmind-v5.7.6.1_qwen_stage_2-cw-12K-16bit is a machine learning model from jastorj. Use it for the machine learning task on the model card, and read the license before you ship it in a product. The card lists the license as apache-2.0.
This model is a fine-tuned version of Qwen/Qwen2.5-Coder-7B-Instruct on the NL2SQL++ v5.7.6.1qwenstage2 dataset with code-with-thought reasoning.
Downloads · 30 days
4
5% of all-time downloads
All-time downloads
85
Public
Parameters
7.6B
15.2 GB on disk
Likes
0
Public
Click a slice to open those files.
.safetensors15.2 GB · 100%
From the Hugging Face model README
This model is a fine-tuned version of Qwen/Qwen2.5-Coder-7B-Instruct on the NL2SQL++ v5.7.6.1_qwen_stage_2 dataset with code-with-thought reasoning.
<|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:
-- Your SQL query
<|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
SELECT MIN(instructor.salary), instructor.dept_name FROM spider_training_bucket.college_2.instructor GROUP BY instructor.dept_name HAVING AVG(instructor.salary) > (SELECT AVG(instructor__1.salary) FROM spider_training_bucket.college_2.instructor AS instructor__1)
<|im_end|>