CREATE TABLE instructor (dept_name VARCHAR2, name VARCHAR2)

Find the department name of the instructor whose name contains 'Soisalon'.
SELECT dept_name FROM instructor WHERE name LIKE '%Soisalon%'
SELECT "dept_name" FROM "instructor" WHERE "name" LIKE '%Soisalon%'