分组
SELECT hire_date, COUNT(*)
FROM employees
GROUP BY hire_date;SELECT extract(year from hire_date), COUNT(*)
FROM employees
GROUP BY extract(year from hire_date);
-- GROUP BY 1;SELECT extract(year from hire_date), department_id, COUNT(*)
FROM employees…