Database: e_learning
Question: Find the common login name of course authors and students.
SQL:
SELECT login_name FROM Course_Authors_and_Tutors INTERSECT SELECT login_name FROM Students