Can someone help with making the SQL query? I'm having trouble working it out.

-21. In a local or national crisis, we need to find all the people who once held a job position of the special job category identifier. List per_id, name, job position title and the years the person worked (starting year and ending year). with unemployed (per_id) as ((select per_id from person) minus (select per_id from works where end date