How to generate report showing questionnaire of checklist

Summary:

I have attempted to generate a BI report displaying offboarding questionnaire responses labeled 'Interview.' However, my SQL query is producing duplicate data and some null rows that need to be removed in order to have a single line for each employee, any help

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

select 

pact.CHECKLIST_NAME,

PATL.TASK_NAME,

hprv.QUESTIONNAIRE_ID,

papf.person_number employee_number,

ppnf.full_name Employee_Name,

MANAGER_NUMBER.managerno Manager_Number,

MANAGER_Name.managername,