Untitled
unknown
plain_text
5 months ago
703 B
3
Indexable
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;
Editor is loading...
Leave a Comment