Untitled

SELECT MAX(salary) AS highest_salary 
FROM employees;


SELECT first_name, COUNT(*) AS frequency 
FROM employees 
GROUP BY first_name;


SELECT department_id, SUM(salary) AS total_salaries 
FROM employees 
GROUP BY department_id;


SELECT department_id, SUM(salary) AS total_salaries 
FROM employees 
GROUP BY department_id 
HAVING SUM(salary) > 100000;

SELECT COUNT(*) AS total_employees 
FROM employees 
WHERE department_id = 100;


SELECT CONCAT(last_name, ', ', first_name) AS full_name 
FROM employees 
ORDER BY full_name DESC;


SELECT MAX(commission_pct) AS highest_commission, MIN(commission_pct) AS lowest_commission 
FROM employees;