CREATE TABLE Students (student_id VARCHAR, first_name VARCHAR)
CREATE TABLE Assessment_Notes (date_of_notes VARCHAR, student_id VARCHAR)

Find the dates of assessment notes for students with first name 'Fanny'.
SELECT T1.date_of_notes FROM Assessment_Notes AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.first_name = "Fanny"
SELECT "T1"."date_of_notes" FROM "Assessment_Notes" AS "T1" JOIN "Students" AS "T2" ON "Fanny" = "T2"."first_name" AND "T1"."student_id" = "T2"."student_id"