CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE restaurant (resid NUMBER, resname CLOB, address CLOB, rating NUMBER)
CREATE TABLE visits_restaurant (stuid NUMBER, resid NUMBER, time TIME, spent NUMBER)
CREATE TABLE type_of_restaurant (resid NUMBER, restypeid NUMBER)
CREATE TABLE restaurant_type (restypeid NUMBER, restypename CLOB, restypedescription CLOB)

List all female students age is older than 18 who is not majoring in 600. List students' first name and last name.
SELECT fname, lname FROM student WHERE age > 18 AND major <> 600 AND sex = 'F'
SELECT "fname", "lname" FROM "student" WHERE "age" > 18 AND "major" <> 600 AND "sex" = 'F'