text: CREATE TABLE instructor (name VARCHAR) -- Find the names of all instructors whose name includes the substring “dar”. SELECT name FROM instructor WHERE name LIKE '%dar%' CREATE TABLE instructor (name VARCHAR) -- List in alphabetic order the names of all distinct instructors. SELECT DISTINCT name FROM instructor ORDER BY name CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR) -- Find courses that ran in Fall 2009 or in Spring 2010. SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 UNION SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010 CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR) -- Find courses that ran in Fall 2009 and in Spring 2010. SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 INTERSECT SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010 CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR) -- Find courses that ran in Fall 2009 but not in Spring 2010. SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 EXCEPT SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010 CREATE TABLE instructor (salary INTEGER) -- Find the salaries of all distinct instructors that are less than the largest salary. SELECT DISTINCT salary FROM instructor WHERE salary < (SELECT MAX(salary) FROM instructor) CREATE TABLE teaches (ID VARCHAR, semester VARCHAR, YEAR VARCHAR) -- Find the total number of instructors who teach a course in the Spring 2010 semester. SELECT COUNT(DISTINCT ID) FROM teaches WHERE semester = 'Spring' AND YEAR = 2010