text: CREATE TABLE teaches (id VARCHAR) -- How many different instructors have taught some course? SELECT COUNT(DISTINCT id) FROM teaches CREATE TABLE department (budget INTEGER, dept_name VARCHAR) -- Find the total budgets of the Marketing or Finance department. SELECT SUM(budget) FROM department WHERE dept_name = 'Marketing' OR dept_name = 'Finance' CREATE TABLE instructor (dept_name VARCHAR, name VARCHAR) -- Find the department name of the instructor whose name contains 'Soisalon'. SELECT dept_name FROM instructor WHERE name LIKE '%Soisalon%' CREATE TABLE classroom (building VARCHAR, capacity VARCHAR) -- How many rooms whose capacity is less than 50 does the Lamberton building have? SELECT COUNT(*) FROM classroom WHERE building = 'Lamberton' AND capacity < 50 CREATE TABLE department (dept_name VARCHAR, budget INTEGER) -- Find the name and budget of departments whose budgets are more than the average budget. SELECT dept_name, budget FROM department WHERE budget > (SELECT AVG(budget) FROM department) CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR) -- what is the name of the instructor who is in Statistics department and earns the lowest salary? SELECT name FROM instructor WHERE dept_name = 'Statistics' ORDER BY salary LIMIT 1 CREATE TABLE course (title VARCHAR, dept_name VARCHAR) -- Find the title of course that is provided by both Statistics and Psychology departments. SELECT title FROM course WHERE dept_name = 'Statistics' INTERSECT SELECT title FROM course WHERE dept_name = 'Psychology'