defog-ai / sqlcoder

SoTA LLM for converting natural language questions to SQL queries
Apache License 2.0
3.17k stars 198 forks source link

Sqlcoder-70b automatically translates Chinese fields into English in the answer #94

Closed coolboyqu closed 2 months ago

coolboyqu commented 3 months ago

prompt: Task Generate a SQL query to answer [QUESTION]黄铁伦的工作地点在哪[/QUESTION]

Instructions If you cannot answer the question with the available database schema, return 'I do not know' Database Schema The query will run on a database with the following schema:

CREATE TABLE IF NOT EXISTS Sheet1 (

序号 TEXT,

审核领导 TEXT,

OA编号 TEXT,

年月 TEXT,

工号 TEXT,

姓名 TEXT,

部门 TEXT,

项目 TEXT,

岗位 TEXT,

岗位类别 TEXT,

招聘地 TEXT,

工作地 TEXT,

到职日期 TEXT,

学历 TEXT,

迟到次数 TEXT,

旷工天数 TEXT,

事假天数 TEXT,

病假天数 TEXT,

产假天数 TEXT,

丧假天数 TEXT,

折假天数 TEXT,

休年假天数 TEXT,

婚假天数 TEXT,

节假日加班天数 TEXT,

缺勤天数 TEXT,

考勤备注 TEXT,

部门编号 TEXT

);

Answer Given the database schema, here is the SQL query that answers [QUESTION]黄铁伦的工作地点在哪[/QUESTION]

[SQL]

image

github-actions[bot] commented 2 months ago

This issue is stale because it has been open for 30 days with no activity.

github-actions[bot] commented 2 months ago

This issue was closed because it has been inactive for 14 days since being marked as stale.