select survey_id, question_text
from survsimp_questions
where question_id = :question_id
select label as response_text
from survsimp_question_choices
where choice_id = :choice_id
select name from survsimp_surveys where survey_id = :survey_id
select
first_names || ' ' || last_name as responder_name,
person_id,
creation_date
from
acs_objects,
survsimp_responses sr,
persons u,
survsimp_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