Assuming respondent is required, the following result was found.
AS "Question Number", q."Text" AS "Question", r."Text" AS "Answer", r2."Status" AS "Status", r3."Variable Value" AS "Respondent Email" FROM "Responses (Zoho Survey)" r LEFT JOIN "Surveys (Zoho Survey)" s ON r."Survey ID" = s."ID" LEFT JOIN "Questions...