SELECT COUNT(*),department_id FROM employees GROUP BY department_id HAVING COUNT(*)>2; #:查詢每個工種有獎金的員工的最高工資>12000的工種編號和最高工資
SELECT MAX(salary),job_id FROM employees WHERE commission_pct IS NOT NULL GROUP BY job_id HAVING MAX(salary)>12000; #篩選12000放在分組后是因為，要等Max計算完再開始篩選 #查詢領導編號>102的每個領導手下的員工的最低工資>5000的領導編號，以及其最底工資
SELECT MIN(salary),manager_id FROM employees WHERE manager_id>102 GROUP BY manager_id HAVING MIN(salary)>5000;
