How many different student logins are there?
select count ( distinct login_name ) from students
how many different author logins are there?
select count ( distinct login_name ) from course_authors_and_tutors
How many login names are in both authors and students?
select login_name from course_authors_and_tutors intersect select login_name from students