human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
Which classrooms are used by grade 5?
assistant
SELECT DISTINCT classroom FROM list WHERE grade = 5
human
Find the last names of students studying in room 111.
assistant
SELECT lastname FROM list WHERE classroom = 111
human
Find the first names of students studying in room 108.
assistant
SELECT firstname FROM list WHERE classroom = 108
human
What are the first names of students studying in room 107?
assistant
SELECT DISTINCT firstname FROM list WHERE classroom = 107
human
Which grade is studying in classroom 103?
assistant
SELECT DISTINCT grade FROM list WHERE classroom = 103
human
Which grade is studying in room 105?
assistant
SELECT DISTINCT grade FROM list WHERE classroom = 105 ;