SELECT DISTINCT job_name FROM employees;

SELECT first_name, last_name, salary, salary*.15 AS PF 
	FROM employees;
	
SELECT EMPLOYEE_ID AS id, CONCAT( first_name, ' ', last_name) AS full_name
	FROM employees;

SELECT DISTINCT DEPARTMENT_ID 	FROM employees;d
SELECT DISTINCT JOB_ID 	FROM employees;	


SELECT GROUP_CONCAT(e.EMPLOYEE_ID), e.SALARY
FROM employees AS e
GROUP BY e.SALARY
	
SELECT e.EMPLOYEE_ID, CONCAT(e.FIRST_NAME, ' ', e.LAST_NAME) AS full_name, e.SALARY
FROM employees AS e

SELECT e.EMPLOYEE_ID, CONCAT(e.FIRST_NAME, ' ', e.LAST_NAME) AS full_name, CONCAT(em.FIRST_NAME, ' ', em.LAST_NAME) AS manager
FROM employees AS e
	LEFT JOIN employees em ON e.MANAGER_ID = em.EMPLOYEE_ID	
	
SELECT e.EMPLOYEE_ID, CONCAT(e.FIRST_NAME, ' ', e.LAST_NAME) AS full_name, CONCAT(em.FIRST_NAME, ' ', em.LAST_NAME) AS manager
FROM employees AS e
	LEFT JOIN employees em ON e.MANAGER_ID = em.EMPLOYEE_ID
	GROUP BY e.EMPLOYEE_ID
		
SELECT e.EMPLOYEE_ID, CONCAT(e.FIRST_NAME, ' ', e.LAST_NAME) AS full_name, e.SALARY, d.DEPARTMENT_NAME, 
	CONCAT(em.FIRST_NAME, ' ', em.LAST_NAME) AS manager, CONCAT(l.STREET_ADDRESS, ' ', l.CITY, ' ', l.POSTAL_CODE) AS dept_location
	FROM employees AS e
	LEFT JOIN departments d ON e.DEPARTMENT_ID = d.DEPARTMENT_ID
	LEFT JOIN employees em ON d.MANAGER_ID = em.EMPLOYEE_ID
	LEFT JOIN locations l ON d.LOCATION_ID = l.LOCATION_ID

		
	
SELECT SUM(e.SALARY)
FROM employees AS e

SELECT MIN(e.SALARY)
FROM employees AS e

SELECT MAX(e.SALARY)
FROM employees AS e