CREATE TABLE Assessment_Notes (text_of_notes VARCHAR2, teacher_id VARCHAR2)
CREATE TABLE Teachers (teacher_id VARCHAR2, last_name VARCHAR2)

Find the texts of assessment notes for teachers with last name 'Schuster'.
SELECT T1.text_of_notes FROM Assessment_Notes AS T1 JOIN Teachers AS T2 ON T1.teacher_id = T2.teacher_id WHERE T2.last_name = "Schuster"
SELECT "T1"."text_of_notes" FROM "Assessment_Notes" "T1" JOIN "Teachers" "T2" ON "Schuster" = "T2"."last_name" AND "T1"."teacher_id" = "T2"."teacher_id"