SQLize | PHPize | SQLtest

CREATE TABLE Departments ( DeptID INT PRIMARY KEY, DeptName VARCHAR(50) ); CREATE TABLE Employees ( EmpID INT PRIMARY KEY, Fname VARCHAR(50), Sname VARCHAR(50), Family VARCHAR(50), DeptID INT, Salary DECIMAL(10,2), HireDate DATE, MGR INT, FOREIGN KEY (DeptID) REFERENCES Departments(DeptID) ); INSERT INTO Departments (DeptID, DeptName) VALUES (101, 'IT'), (102, 'Accountant'), (103, 'HR'), (104, 'Sales'), (105, NULL) ); INSERT INTO Employees (EmpID, Fname, Sname, Family, DeptID, Salary, HireDate, MGR) VALUES (1, 'John', 'Doe', 'Smith', 101, 100.00, '2020-01-15', 2), (2, 'Jane', 'Doe', 'Johnson', 102, 500.00, '2019-03-22', 3), (3, 'Alice', 'Williams', 'Brown', 103, 650.00, NULL, NULL), (4, 'Bob', 'Jones', 'Taylor', 104, 750.00, '2022-09-10', 2), (5, 'Charlie', 'Miller', 'Davis', 101, 900.00, '2018-11-25', 2), (6, 'David', 'Wilson', 'Martinez', 105, 300.00, NULL, 3), (7, 'Emma', NULL, 'Hernandez', 102, 400.00, '2019-05-16', 6), (8, 'Frank', 'Taylor', 'Garcia', 104, 400.00, '2021-08-19', 2), (9, 'Grace', 'Anderson', 'Lopez', 103, 550.00, '2022-01-12', 6), (10, 'Henry', 'Thomas', 'Jackson', 105, 1023.00, '2023-04-07', 8), (11, 'Ahmad', 'H', 'KH', 103, 5000.00, '2024-12-01', 1);