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 EmployeesVALUES (1, 'John', 1),(2, 'Mary', 2),(3, 'Steve', 2);INSERT INTO Departments VALUES(1, 'Engineering'),(2, 'Sales');INSERT INTO ProjectsVALUES(1, 'Project 1', 1),(2, 'Project 2', 2);INSERT INTO EmployeeProjectsVALUES(1, 1, 10),(2, 1, 20),(3, 2, 15);DELETE EPFROM EmployeeProjects EPINNER JOIN Employees E ON EP.EmployeeID = E.EmployeeIDINNER JOIN Projects P ON EP.ProjectID = P.ProjectIDINNER JOIN Departments D ON P.DepartmentID = D.DepartmentIDWHERE E.Name = 'Mary' AND D.DepartmentName = 'Sales' سارتر چه بر سر جایزۀ نوبل آورد...
ادامه مطلبما را در سایت سارتر چه بر سر جایزۀ نوبل آورد دنبال می کنید
برچسب : نویسنده : شهریاری web2web بازدید : 102 تاريخ : چهارشنبه 15 شهريور 1402 ساعت: 8:35