Tell me Cary's login name.
select login_name from students where personal_name = "Cary"
How about Autumn's login name.
select login_name from students where personal_name = "Autumn"
Tell me the common login name of course authors and students.
select login_name from course_authors_and_tutors intersect select login_name from students