human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the lname of grade 2 | Do you mean what are the last names of the students in grade 2? | what is the lname of classroom 101
assistant
SELECT lastname FROM list WHERE classroom = 101;
human
what is the fname of class room 102
assistant
SELECT firstname FROM list WHERE classroom = 102 ;