-- 1 Write a query to get the number of designations available in the employees table-- 2 Write a query to get the job_id and related employees idjob_id Employees IDAC_ACCOUNT 206AC_MGR 205AD_ASST

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;