Task: Text to Code
Input (English): SQL: SELECT LastName FROM teachers WHERE FirstName = "GELL"
Feedback: Full name of the list table should be GELL TAMI .
Output (English): SELECT T2.lastname FROM list AS T1 JOIN teachers AS T2 ON T1.classroom  =  T2.classroom WHERE T1.firstname  =  "GELL" AND T1.lastname  =  "TAMI"