--CREATE TABLE Employees (
-- EmployeeID INT,
-- FirstName VARCHAR(50),
-- LastName VARCHAR(50),
-- Department VARCHAR(50),
-- Salary INT
--);
--INSERT INTO Employees (EmployeeID, FirstName, LastName, Department, Salary)
--VALUES
-- (1, 'John', 'Williams', 'IT', 500000),
-- (2, 'Sara', 'Johnson', 'HR', 400000),
-- (3, 'Michael', 'Smith', 'Sales', 600000),
-- (4, 'Emily', 'Brown', 'IT', 550000),
-- (5, 'David', 'Jones', 'Marketing', 450000),
-- (6, 'Jessica', 'Davis', 'Sales', 550000),
-- (7, 'Robert', 'Miller', 'HR', 420000),
-- (8, 'Jennifer', 'Wilson', 'Marketing', 480000),
-- (9, 'Christopher', 'Anderson', 'Sales', 520000),
-- (10, 'Lisa', 'Taylor', 'IT', 480000);
--1
--SELECT FirstName, LastName, Salary
--FROM Employees
--WHERE Department = 'IT';
--2
--SELECT AVG(Salary) AS AverageSalary
--FROM Employees;
--3
--SELECT MAX(Salary) AS HighestSalary
--FROM Employees;
--4
--SELECT TOP 3 FirstName, LastName, Salary
--FROM Employees
--ORDER BY salary DESC;
--5
--UPDATE Employees
--SET Salary = 5000
--WHERE EmployeeID = 5;
--6
--SELECT SUM(Salary) AS TotalSalaryBudget
--FROM Employees
--WHERE Department = 'IT';
--7
--SELECT FirstName, LastName
--FROM Employees
--WHERE FirstName LIKE 'J%';
--8
--SELECT Department, AVG(Salary) AS AverageSalary
--FROM Employees
--GROUP BY Department;
--9
--SELECT FirstName, LastName, Salary
--FROM Employees
--WHERE Salary > (SELECT AVG(Salary) FROM Employees);
--10
--SELECT FirstName, LastName, Salary
--FROM Employees
--WHERE Department = 'Sales' and Salary > 5000;
--11
--DELETE FROM employees
--WHERE EmployeeID = 7;
--13
--UPDATE Employees
--SET salary = salary * 1.1
--WHERE department = 'Marketing';
--14
--SELECT department, SUM(Salary) AS total_salary
--FROM Employees
--GROUP BY department;
--15
--SELECT FirstName, LastName, Salary
--FROM Employees
--ORDER BY salary ASC;
--16
--Select SUM(Salary) AS sumofsalaries
--FROM Employees
--17
--SELECT FirstName, LastName, Salary
--FROM Employees
--WHERE salary >= 4000 AND salary <= 5500;
--18
--UPDATE Employees
--SET department = 'Marketing'
--WHERE EmployeeID = 3;
--20
--SELECT department, AVG(salary) AS average_salary
--FROM Employees
--WHERE department <> 'HR'
--GROUP BY department;
--21
--SELECT FirstName, LastName, Salary
--FROM Employees
--WHERE firstname LIKE '_a%';
--22
--SELECT department, COUNT(*) AS employee_count
--FROM employees
--GROUP BY department;
--23
--SELECT FirstName, LastName, Salary
--FROM Employees
--ORDER BY salary DESC;
--25
--SELECT AVG(salary) AS average_salary
--FROM Employees
--WHERE salary > 5000;
--26
--SELECT FirstName, LastName, Salary
--FROM Employees
--ORDER BY RAND();
--27
--SELECT MAX(salary) - MIN(salary) AS salary_difference
--FROM Employees;
--28
--SELECT *
--FROM Employees
--WHERE FirstName LIKE '_[aeiou]%';
--29
--SELECT *
--FROM Employees
--WHERE FirstName like '_____'
--30
--SELECT FirstName, Lastname, salary
--FROM Employees
--Order by LastName ASC;
--31
--SELECT *
--FROM Customers
--WHERE Name LIKE '%_ss_%' OR Name LIKE '%_nn_%';
--FROM employees
--WHERE FirstName LIKE '%_ss_%' OR FirstName LIKE '%_nn_%';
