SQL Queries: Count Designations and Get Job IDs with Employee IDs

SELECT COUNT(DISTINCT designation) AS num_of_designations FROM employees;

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