CREATE TABLE employe(
    employe_id int PRIMARY KEY,
    name VARCHAR(20),
    salary varchar(20),
    department varchar(20),
    hire_date DATE
    );
    
    INSERT INTO employe(employe_id, name, salary, department, hire_date)
VALUES 
    (1, 'Alice Smith', 9000, 'engineering', '2023-02-15'),
    (2, 'Bob Johan', 8500, 'marketing', '2022-11-05'),
    (3, 'Carol Lee', 9500, 'engineering', '2021-07-20'),
    (4, 'Dave Brown', 8000, 'sales', '2023-03-10'),
    (5, 'Ece Davis', 10000, 'HR', '2022-08-30');
    
    1))SELECT *
FROM employe
WHERE department = 'engineering'
  AND salary > 8000;
  
  2))SELECT *
FROM employees e
WHERE salary > (
    SELECT AVG(salary)
    FROM employees
    WHERE department = e.department
);

3))SELECT name
FROM employe
WHERE department = 'HR';

4))SELECT department, COUNT(*) AS employe_count
FROM employe
GROUP BY department;

5)SELECT *
FROM employe
WHERE YEAR(hire_date) = 2022
  AND salary > 8000;

6))SELECT *
FROM employe
WHERE department <> 'engineering'
  AND salary < 9000;


7))SELECT 
    MAX(salary) AS highest_salary,
    MIN(salary) AS lowest_salary
FROM employe;

9))SELECT COUNT(*) AS count_employe
FROM employe
WHERE name LIKE 'C%';
10))
SELECT *
FROM employe
WHERE name LIKE '_L%';