What are the emails of the students with the first name Emma?
select email_address from students where first_name = "Emma"
What is that person's student id?
select student_id from students where last_name = "Rohan"
What is their email address?
select email_address from students where student_id = 4