Find the common login name of course authors and students.
CREATE TABLE Course_Authors_and_Tutors (login_name VARCHAR); CREATE TABLE Students (login_name VARCHAR)
SELECT login_name FROM Course_Authors_and_Tutors INTERSECT SELECT login_name FROM Students
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Course_Authors_and_Tutors (login_name VARCHAR); CREATE TABLE Students (login_name VARCHAR) Question: Find the common login name of course authors and students. [/INST] SELECT login_name FROM Course_Authors_and_Tutors INTERSECT SELECT login_name FROM Students </s>