select question_id, question_text, abstract_data_type, sort_order from survey_questions where section_id in (select section_id from survey_sections where survey_id=:survey_id) order by sort_order select count(*) as n_responses, (case when boolean_answer = 't' then 'True' when boolean_answer = 'f' then 'False' end) as boolean_answer from survey_ques_responses_latest where question_id = :question_id group by boolean_answer order by boolean_answer desc select count(*) as n_responses, number_answer from survey_ques_responses_latest where question_id = :question_id group by number_answer order by number_answer select avg(number_answer) as mean, stddev(number_answer) as standard_deviation from survey_ques_responses_latest where question_id = :question_id select count(*) as n_responses, label, qc.choice_id from survey_ques_responses_latest qr, survey_question_choices qc where qr.choice_id = qc.choice_id and qr.question_id = :question_id group by label, sort_order, qc.choice_id order by sort_order select cr.title, qr.question_id, qr.response_id from cr_revisions cr, survey_ques_responses_latest qr where revision_id=attachment_answer and qr.question_id=question_id select count(*) from survey_responses_latest where survey_id=:survey_id