CREATE TABLE dependent (essn NUMBER, dependent_name CLOB, sex CLOB, bdate CLOB, relationship CLOB)
CREATE TABLE department (dname CLOB, dnumber NUMBER, mgr_ssn NUMBER, mgr_start_date CLOB)
CREATE TABLE project (pname CLOB, pnumber NUMBER, plocation CLOB, dnum NUMBER)
CREATE TABLE employee (fname CLOB, minit CLOB, lname CLOB, ssn NUMBER, bdate CLOB, address CLOB, sex CLOB, salary NUMBER, super_ssn NUMBER, dno NUMBER)
CREATE TABLE works_on (essn NUMBER, pno NUMBER, hours NUMBER)
CREATE TABLE dept_locations (dnumber NUMBER, dlocation CLOB)

find all dependent names who have a spouse relation with some employee.
SELECT dependent_name FROM dependent WHERE relationship = 'Spouse'
SELECT "dependent_name" FROM "dependent" WHERE "relationship" = 'Spouse'