CREATE TABLE Employees
(
EmployeeID INT PRIMARY KEY,
Name VARCHAR(100),
DepartmentID INT
);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'
سارتر چه بر سر جایزۀ نوبل آورد...
ما را در سایت سارتر چه بر سر جایزۀ نوبل آورد دنبال می کنید
برچسب : نویسنده : شهریاری web2web بازدید : 103 تاريخ : چهارشنبه 15 شهريور 1402 ساعت: 8:35