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