The technical reference guide containing the dictionary must be your starting point for such information :
note that the cr:1223456 is the persid of your ticket that you can join with the call_req table to retrieve the ref_num
DECLARE @StartDate DATETIME, @EndDate DATETIME
SET @StartDate = DATEADD(mm, DATEDIFF(mm, 0, getdate()) - 1, 0)
SET @EndDate = dateadd(dd, -1, DATEADD(mm, 1, @StartDate))
SELECT call_req.ref_num, DATEADD(ss, survey.last_mod_dt, '1970/01/01 00:00:00') AS [Survey Date], call_req.type AS [Call Type], prob_ctg.sym AS category, [Group].last_name AS Group_name,
requester.first_name AS [Requester first name], requester.last_name AS [Requester last name], customer.first_name AS [Customer first name],
customer.last_name AS [Customer last name], survey.nx_comment AS [Survey comment], survey_question.sequence AS [Question Sequence],
survey_question.txt AS [Question text], survey_answer.sequence AS [Answer Sequence], survey_answer.txt AS [Answer Text],
survey_answer.selected AS [Answer Selected]
FROM ca_contact AS customer RIGHT OUTER JOIN
survey LEFT OUTER JOIN
call_req LEFT OUTER JOIN
ca_contact AS [Group] ON call_req.group_id = [Group].contact_uuid LEFT OUTER JOIN
prob_ctg ON call_req.category = prob_ctg.persid LEFT OUTER JOIN
usp_owned_resource AS CI ON call_req.affected_rc = CI.owned_resource_uuid ON survey.object_id = call_req.id ON
customer.contact_uuid = call_req.customer LEFT OUTER JOIN
ca_contact AS requester ON call_req.requested_by = requester.contact_uuid FULL OUTER JOIN
survey_question LEFT OUTER JOIN
survey_answer ON survey_question.id = survey_answer.own_srvy_question ON survey.id = survey_question.owning_survey
WHERE (survey.object_type = N'cr') AND (DATEADD(ss, survey.last_mod_dt, '1970/01/01 00:00:00') BETWEEN @StartDate AND @EndDate)
ORDER BY call_req.ref_num