CREATE TABLE student_course_attendance (student_id DECIMAL, course_id DECIMAL, date_of_attendance TIME)
CREATE TABLE people (person_id DECIMAL, first_name TEXT, middle_name TEXT, last_name TEXT, cell_mobile_number TEXT, email_address TEXT, login_name TEXT, password TEXT)
CREATE TABLE candidate_assessments (candidate_id DECIMAL, qualification TEXT, assessment_date TIME, asessment_outcome_code TEXT)
CREATE TABLE addresses (address_id DECIMAL, line_1 TEXT, line_2 TEXT, city TEXT, zip_postcode TEXT, state_province_county TEXT, country TEXT)
CREATE TABLE students (student_id DECIMAL, student_details TEXT)
CREATE TABLE courses (course_id TEXT, course_name TEXT, course_description TEXT, other_details TEXT)
CREATE TABLE people_addresses (person_address_id DECIMAL, person_id DECIMAL, address_id DECIMAL, date_from TIME, date_to TIME)
CREATE TABLE candidates (candidate_id DECIMAL, candidate_details TEXT)
CREATE TABLE student_course_registrations (student_id DECIMAL, course_id DECIMAL, registration_date TIME)

What is the id of the candidate whose email is stanley.monahan@example.org?
SELECT T2.candidate_id FROM people AS T1 JOIN candidates AS T2 ON T1.person_id = T2.candidate_id WHERE T1.email_address = "stanley.monahan@example.org"
SELECT "T2"."candidate_id" FROM "people" AS "T1" JOIN "candidates" AS "T2" ON "T1"."person_id" = "T2"."candidate_id" WHERE "T1"."email_address" = "stanley.monahan@example.org"