Generate SQL from just table/column names

The prompt

Table departments, columns = [DepartmentId, DepartmentName]
Table students, columns = [DepartmentId, StudentId, StudentName]
Create a MySQL query for all students in the Computer Science Department

Expected result

A correct SQL query joining students to departments on DepartmentId and filtering DepartmentName = 'Computer Science'.

Why it works

Shows the minimum context a model needs for reliable SQL generation: just table names and column lists — no full schema DDL required, as long as the relationship between tables is inferable from shared column names.