By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Departments (
DepartmentID INT PRIMARY KEY,
Department_Name VARCHAR(14) ,
Location VARCHAR(13)
);
CREATE TABLE Emp (
Emp_No INT PRIMARY KEY,
Employee_Name VARCHAR(10),
Job VARCHAR(9),
ManagerID INT,
Hire_Date DATE,
Salary DECIMAL(7,2),
Comm DECIMAL(7,2),
DepartmentID INT,
FOREIGN KEY (DepartmentID) REFERENCES Departments(DepartmentID)
);
INSERT INTO Departments VALUES
(10,'ACCOUNTING','NEW YORK')
, (20,'RESEARCH', 'DALLAS')
, (30,'SALES', 'CHICAGO')
, (40,'OPERATIONS','BOSTON')
Records: 4 Duplicates: 0 Warnings: 0
INSERT INTO Emp
(Emp_No, Employee_Name, Job, ManagerID, Hire_Date, Salary, Comm, DepartmentID) VALUES
(7369,'SMITH','CLERK', 7902,'2021-12-17',800,NULL,20)
, (7499,'ALLEN','SALESMAN', 7698,'2021-02-20',1600,300,30)
, (7521,'WARD','SALESMAN', 7698,'2021-02-22',1250,500,30)
, (7566,'JONES','MANAGER', 7839,'2021-04-02',2975,NULL,20)
, (7654,'MARTIN','SALESMAN',7698,'2021-09-28',1250,1400,30)
, (7698,'BLAKE','MANAGER', 7839,'2021-05-01',2850,NULL,30)
, (7782,'CLARK','MANAGER', 7839,'2021-06-09',2450,NULL,10)
, (7788,'SCOTT','ANALYST', 7566,'2021-07-13',3000,NULL,20)
, (7839,'KING','PRESIDENT', NULL,'2021-11-17',5000,NULL,10)
, (7844,'TURNER','SALESMAN',7698,'2021-09-08',1500,0,30)
, (7876,'ADAMS','CLERK', 7788,'2021-07-13',1100,NULL,20)
, (7900,'JAMES','CLERK', 7698,'2021-12-03',950,NULL,30)
, (7902,'FORD','ANALYST', 7566,'2021-12-03',3000,NULL,20)
, (7934,'MILLER','CLERK', 7782,'2021-01-23',1300,NULL,10)
Records: 14 Duplicates: 0 Warnings: 0
SELECT *
FROM Emp
WHERE Salary > 2000
AND Hire_Date >= DATE_SUB(CURRENT_DATE, INTERVAL 10 MONTH)
ORDER BY emp_no ASC;
| Emp_No | Employee_Name | Job | ManagerID | Hire_Date | Salary | Comm | DepartmentID |
|---|