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);