can you show me a list of grades?
select grade from list
can you show me a list of first name that starting with 'J'?
select firstname from list where firstname like "J%"
can you show me a list of last name that starting with 'J'?
select lastname from list where lastname like "J%"
can you show me a list of teacher class room?
select classroom from teachers
"Find the last names of all the teachers that teach GELL TAMI.
select t2.lastname from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t1.firstname = "GELL" and t1.lastname = "TAMI"