-- create a table
CREATE TABLE Employee (
  EmpID INTEGER PRIMARY KEY,
 FirstName VARCHAR (30),
  LastName VARCHAR(30), 
    Gender CHAR (1),
 Department VARCHAR(20),
            salary REAL,
          HireDate  DATE
);
-- insert some values
INSERT INTO Employee  (EmpID , FirstName , LastName , Gender , Department , Salary , HireDate ) VALUES
(1, 'Lafi', 'alshammari', 'M', 'Marketing', 55000, '2022-09-15'),
(2, 'saad', 'ahmad', 'M', 'Finance', 67000, '2022-07-30'),
(3, 'Hamad', 'naser', 'M', 'HR', 45000, '2022-01-12'),
(4, 'sami', 'fisal', 'M', 'IT', 70000, '2020-10-05'),
(5, 'falah', 'alshammari', 'M', 'Marketing', 50000, '2021-05-20');
select * FROM Employee;
select FirstName , LastName FROM Employee;
select * FROM Employee WHERE Department = 'Marketing'; 
select FirstName, LastName FROM Employee WHERE FirstName LIKE('s%');
UPDATE Employee 
    SET Salary = Salary *1.05 
    WHERE Department = 'HR';
select * FROM Employee;
DELETE FROM Employee WHERE EmpID =2;
Select * FROM Employee ;
ALTER TABLE Employee ADD COLUMN Email VARCHAR(50);
ALTER TABLE Employee RENAME COLUMN HireDate TO DateHired;
ALTER TABLE Employee DROP COLUMN Gender ; 
SELECT * FROM Employee;
--Lafi Alshammari 
--ID 202305808