الدوال التجميعية

SELECT COUNT(*)    AS employees,
       MIN(salary) AS lowest,
       MAX(salary) AS highest,
       ROUND(AVG(salary), 2) AS average
FROM employees;

SELECT SUM(quantity * unit_price) AS order_total
FROM order_items
WHERE order_id = 1;