CREATE TABLE instructor (name VARCHAR(255), dept_name VARCHAR(255), salary VARCHAR(255))
Find the names of all instructors in Comp. Sci. department with salary > 80000.
    
SQL: SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.' AND salary > 80000