حذف Delete در Sql Server با استفاده از join ها

CREATE TABLE Departments
(
    DepartmentID INT PRIMARY KEY,
    DepartmentName VARCHAR(100)
);

CREATE TABLE Projects
(
    ProjectID INT PRIMARY KEY,
    ProjectName VARCHAR(100),
    DepartmentID INT
);

CREATE TABLE EmployeeProjects
(
    EmployeeID INT,
    ProjectID INT,
    PRIMARY KEY (EmployeeID, ProjectID),
    HoursWorked INT
);

INSERT INTO Employees
VALUES  
(1, 'John', 1),
(2, 'Mary', 2),
(3, 'Steve', 2);

INSERT INTO Departments
VALUES
(1, 'Engineering'),
(2, 'Sales');

INSERT INTO Projects
VALUES
(1, 'Project 1', 1),
(2, 'Project 2', 2);

INSERT INTO EmployeeProjects
VALUES
(1, 1, 10),
(2, 1, 20),
(3, 2, 15);

DELETE EP
FROM EmployeeProjects EP
INNER JOIN Employees E ON EP.EmployeeID = E.EmployeeID
INNER JOIN Projects P ON EP.ProjectID = P.ProjectID
INNER JOIN Departments D ON P.DepartmentID = D.DepartmentID
WHERE E.Name = 'Mary' AND D.DepartmentName = 'Sales'