SQL Query for Employee Designations and Job IDs

SELECT COUNT(DISTINCT designation) AS num_designations FROM employees;

SELECT job_id, LISTAGG(employee_id, ', ') WITHIN GROUP (ORDER BY employee_id) AS employees FROM employees GROUP BY job_id;