Schema: CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR)
Question: Find the names of all instructors in computer science department
SQL: SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.'