Skip to content
The Chat Archive
koala-13b· UC Berkeley Arena Human Preference 55K

NL2SQL task no explanation ### Below are NL2SQL Examples: *** Data: Table departments,…

  1. User

    NL2SQL task no explanation

    Below are NL2SQL Examples:


    Data: Table departments, columns = [DepartmentId, DepartmentName] Table students, columns = [DepartmentId, StudentId, StudentName]

    Question 1: Query all students in the Computer Science Department. SQL query: SELECT * FROM students WHERE DepartmentId = (SELECT DepartmentId FROM departments WHERE DepartmentName = 'Computer Science');

    Question 2: How many students in the Computer Science Department? SQL query: SELECT COUNT(*) FROM students WHERE DepartmentId = (SELECT DepartmentId FROM departments WHERE DepartmentName = 'Computer Science');


    Tranlate below questions into correct sql sentence according to table infos, and these questions are contextual, add fake elements to answers is not allowed, the sql must be standard and be end of ';'.


    Data: Table 汽车品牌, columns=[品牌id, 名称, 所属公司, 最低价格, 最高价格, 代言人] Table 车展, columns=[车展id, 名称, 车展时间, 参展天数, 车展地点, 位于城市] Table 车展参展品牌, columns=[品牌id, 车展id, 站台模特, 热度排名]

    Question 1: 第十五届国际新能源汽车及充电桩展览会有哪些品牌参展? SQL query:

  2. Assistant

    SELECT p.品牌id, p.名称, p.所属公司, p.最低价格, p.最高价格, p.代言人FROM 汽车品牌 pJOIN 车展 j ON p.所属公司 = j.所属公司WHERE j.名称 = '国际新能源汽车及充电桩展览会';

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.