I need this statment in sql language:

Delete all the dependents of employee with Ssn = '666666608'

these are the tabels :

CREATE TABLE EMPLOYEE(

FNAME VARCHAR(15) NOT NULL,

MINIT CHAR(5),

LNAME VARCHAR(15) NOT NULL,

SSN CHAR(9) NOT NULL,

BDATE DATE,

ADDRESS VARCHAR(30),

SEX VARCHAR(2),

SALARY DECIMAL(10,2),

SUPER_SSN CHAR(9),

DNO INT NOT NULL,

PRIMARY KEY(SSN) );

select * from EMPLOYEE;

CREATE TABLE DEPARTMENT(

DNAME VARCHAR(15) NOT NULL,

DNUMBER INT NOT NULL,

MGR_SSN CHAR(9) NOT NULL,

MGR_START_DATE DATE,

PRIMARY KEY(DNUMBER),

UNIQUE(DNAME) );

select * from DEPARTMENT;

CREATE TABLE PROJECT(

PNAME VARCHAR(30) NOT NULL,

PNUMBER INT NOT NULL,

PLOCATION VARCHAR(30) ,

DNUM INT NOT NULL,

PRIMARY KEY(PNUMBER),

UNIQUE(PNAME));

select * from PROJECT;

CREATE TABLE WORKS_ON(

ESSN CHAR(9) NOT NULL,

PNO INT NOT NULL,

HOURS DECIMAL(3,1) NOT NULL,

PRIMARY KEY(ESSN,PNO));

select * from WORKS_ON;

CREATE TABLE DEPT_LOCATIONS(

DNUMBER INT NOT NULL,

DLOCATION VARCHAR(15) NOT NULL,

PRIMARY KEY(DNUMBER,DLOCATION));

select * from DEPT_LOCATIONS;

CREATE TABLE DEPENDENT(

ESSN CHAR(9) NOT NULL,

DEPENDENT_NAME VARCHAR(20) NOT NULL,

SEX CHAR(9),

BDATE DATE,

RELATIONSHIP VARCHAR(20),

PRIMARY KEY (ESSN,DEPENDENT_NAME));

select *

from DEPENDENT;

ALTER TABLE EMPLOYEE ADD CONSTRAINT FK FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER);

ALTER TABLE DEPARTMENT ADD CONSTRAINT FK_DEPT FOREIGN KEY (MGR_SSN) REFERENCES EMPLOYEE(SSN);

ALTER TABLE PROJECT ADD CONSTRAINT FK_PROJECT FOREIGN KEY (DNUM) REFERENCES DEPARTMENT(DNUMBER);

ALTER TABLE WORKS_ON ADD CONSTRAINT FK1_WORKS_ON FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN);

ALTER TABLE WORKS_ON ADD CONSTRAINT FK2_WORKS_ON FOREIGN KEY (PNO) REFERENCES PROJECT(PNUMBER);

ALTER TABLE DEPT_LOCATIONS ADD CONSTRAINT FK_DEPT_LOCATIONS FOREIGN KEY (DNUMBER) REFERENCES DEPARTMENT(DNUMBER);

ALTER TABLE DEPENDENT ADD CONSTRAINT FK_DEPENDENT FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN);

ALTER TABLE EMPLOYEE ADD CONSTRAINT FK2_Employee FOREIGN KEY (SUPER_SSN) REFERENCES EMPLOYEE(SSN);