CREATE TABLE Student_Course_Enrolment (date_of_enrolment VARCHAR, date_of_completion VARCHAR, student_id VARCHAR)
CREATE TABLE Students (student_id VARCHAR, family_name VARCHAR, personal_name VARCHAR)

List the dates of enrollment and completion of the student with family name 'Zieme' and personal name 'Bernie'.
SELECT T1.date_of_enrolment, T1.date_of_completion FROM Student_Course_Enrolment AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.family_name = "Zieme" AND T2.personal_name = "Bernie"
SELECT "T1"."date_of_enrolment", "T1"."date_of_completion" FROM "Student_Course_Enrolment" AS "T1" JOIN "Students" AS "T2" ON "Bernie" = "T2"."personal_name" AND "T1"."student_id" = "T2"."student_id" AND "T2"."family_name" = "Zieme"