Sample Table:- emp_idemp_namejob_namedep_id68319KAYLINGPRESIDENT100166928BLAZEMANAGER300167858SCARLETANALYST200163679SANDRINECLERK2001 sql:- SELECT * FROM ( SELECT * FROM ( SELECT emp_id, emp_name, job_name, dep_id, ROW_NUMBER( ) OVER( ORDER BY dep_id ) AS…