SQLize Online / PHPize Online  /  SQLtest Online

INSERT INTO Departments VALUES ( 'IT', 'New York'), ( 'HR', 'Los Angeles'), ( 'Sales', 'Chicago'), ( 'Marketing', 'Houston'), ( 'Finance', 'Phoenix'); INSERT INTO Employees VALUES ( 'Alice Smith', 'Developer', 60000, 1), ( 'Bob Johnson', 'Manager', 75000, 1), ( 'Charlie Brown', 'HR Specialist', 50000, 2), ('David Wilson', 'Sales Associate', 45000, 3), ('Eva Green', 'Marketing Director', 80000, 4), ( 'Frank White', 'Financial Analyst', 55000, 5), ( 'Grace Lee', 'Developer', 62000, 1), ( 'Henry King', 'Sales Manager', 70000, 3), ( 'Ivy Clark', 'Marketing Specialist', 48000, 4), ( 'Jack Turner', 'HR Manager', 72000, 2); INSERT INTO Projects VALUES ('Project Alpha', '2023-01-01', '2023-06-30', 100000.00), ('Project Beta', '2023-02-01', '2023-07-31', 150000.00), ('Project Gamma', '2023-03-01', '2023-08-31', 120000.00), ('Project Delta', '2023-04-01', '2023-09-30', 200000.00), ('Project Epsilon', '2023-05-01', '2023-10-31', 180000.00); INSERT INTO EmployeeProjects VALUES ( 1, 1, 120), ( 2, 1, 100), ( 1, 2, 80), ( 3, 3, 60), ( 4, 4, 50), ( 5, 5, 40), ( 6, 1, 70), ( 7, 2, 90), ( 8, 3, 110), ( 9, 4, 30);