Which student's age is older than 18 and is majoring in 600? List each student's first and last name.
CREATE TABLE Student (Fname VARCHAR, Lname VARCHAR, Age VARCHAR, Major VARCHAR)
SELECT Fname, Lname FROM Student WHERE Age > 18 AND Major = 600
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Student (Fname VARCHAR, Lname VARCHAR, Age VARCHAR, Major VARCHAR) Question: Which student's age is older than 18 and is majoring in 600? List each student's first and last name. [/INST] SELECT Fname, Lname FROM Student WHERE Age > 18 AND Major = 600 </s>