iTech

CREATE DATABASE EmployeesDatabase;

CREATE TABLE Employees ( EmployeeID INT AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, Age INT NOT NULL, Position VARCHAR(100), IsGraduated BOOLEAN DEFAULT FALSE );

INSERT INTO Employees (FirstName, LastName, Age, Position, IsGraduated) VALUES ('John', 'Doe', 25, 'Junior Developer', FALSE), ('Jane', 'Smith', 29, 'HR Assistant', FALSE), ('Sam', 'Brown', 22, 'Intern', FALSE);

SELECT * FROM Employees WHERE IsGraduated = FALSE;