SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Employé ( id_employe INT PRIMARY KEY, Nom VARCHAR(100), Department VARCHAR(100) ); CREATE TABLE tache ( id_tache INT PRIMARY KEY, Description VARCHAR(255), AssignedTo INT, date DATE ); CREATE TABLE Events ( EventID INT PRIMARY KEY, Title VARCHAR(100), DateAndTime TIMESTAMP, Location VARCHAR(200) ); INSERT INTO tache VALUES (101, 'Finish Report', 1, DATE '2024-04-30'); INSERT INTO tache VALUES (102, 'Marketing Campaign', 2, DATE '2024-05-15'); INSERT INTO tache VALUES (103, 'Interview Candidates', 3, DATE '2024-04-25'); INSERT INTO Events VALUES (201, 'Team Meeting', TIMESTAMP '2024-04-20 09:00:00', 'Conference Room A'); INSERT INTO Events VALUES (202, 'Product Launch', TIMESTAMP '2024-05-10 14:00:00', 'Auditorium'); INSERT INTO Employé VALUES (1, 'John Doe', 'Engineering'); INSERT INTO Employé VALUES (2, 'Jane Smith', 'Marketing'); INSERT INTO Employé VALUES (3, 'Alice Johnson', 'HR'); select*from Events; select*from tache; select*from Employé; CREATE VIEW EngineeringEmployees AS SELECT id_employe, Nom FROM Employé WHERE Department = 'Engineering'; SELECT * FROM EngineeringEmployees;