select section_id, question_text, section_id
from survey_questions
where question_id = :question_id
select label as response_text
from survey_question_choices
where choice_id = :choice_id
select
first_names || ' ' || last_name as responder_name,
person_id as user_id,
creation_date
from
acs_objects,
survey_responses sr,
persons u,
survey_question_responses qr
where
qr.response_id = sr.response_id
and qr.response_id = object_id
and creation_user = person_id
and qr.question_id = :question_id
and qr.choice_id = :choice_id