-- your code goes here-- 1. Create the table
CREATE TABLE Employees (
    ID int,
    Name varchar(255),
    Department varchar(255),
    Salary int
);
 
-- 2. Insert dummy data
INSERT INTO Employees (ID, Name, Department, Salary) VALUES (1, 'John Doe', 'IT', 60000);
INSERT INTO Employees (ID, Name, Department, Salary) VALUES (2, 'Jane Smith', 'HR', 45000);
INSERT INTO Employees (ID, Name, Department, Salary) VALUES (3, 'Mike Johnson', 'IT', 70000);
 
-- 3. The actual question for the student (e.g., "Find all employees in IT")
SELECT * FROM Employees WHERE Department = 'IT';

LS0geW91ciBjb2RlIGdvZXMgaGVyZS0tIDEuIENyZWF0ZSB0aGUgdGFibGUKQ1JFQVRFIFRBQkxFIEVtcGxveWVlcyAoCiAgICBJRCBpbnQsCiAgICBOYW1lIHZhcmNoYXIoMjU1KSwKICAgIERlcGFydG1lbnQgdmFyY2hhcigyNTUpLAogICAgU2FsYXJ5IGludAopOwoKLS0gMi4gSW5zZXJ0IGR1bW15IGRhdGEKSU5TRVJUIElOVE8gRW1wbG95ZWVzIChJRCwgTmFtZSwgRGVwYXJ0bWVudCwgU2FsYXJ5KSBWQUxVRVMgKDEsICdKb2huIERvZScsICdJVCcsIDYwMDAwKTsKSU5TRVJUIElOVE8gRW1wbG95ZWVzIChJRCwgTmFtZSwgRGVwYXJ0bWVudCwgU2FsYXJ5KSBWQUxVRVMgKDIsICdKYW5lIFNtaXRoJywgJ0hSJywgNDUwMDApOwpJTlNFUlQgSU5UTyBFbXBsb3llZXMgKElELCBOYW1lLCBEZXBhcnRtZW50LCBTYWxhcnkpIFZBTFVFUyAoMywgJ01pa2UgSm9obnNvbicsICdJVCcsIDcwMDAwKTsKCi0tIDMuIFRoZSBhY3R1YWwgcXVlc3Rpb24gZm9yIHRoZSBzdHVkZW50IChlLmcuLCAiRmluZCBhbGwgZW1wbG95ZWVzIGluIElUIikKU0VMRUNUICogRlJPTSBFbXBsb3llZXMgV0hFUkUgRGVwYXJ0bWVudCA9ICdJVCc7