select * from survey_predefined_questions where predefined_question_id=:predefined_question_id
update survey_questions
set sort_order = sort_order + 1
where section_id = :section_id
and sort_order > :after
select max(sort_order) from survey_questions
where section_id=:section_id
update survey_questions
set question_text = :question_text
where question_id = :question_id
select distinct survey_question_all_choices(question_id) as
all_choices from
survey_questions where section_id=:section_id
insert into survey_question_choices
(choice_id, question_id, label, sort_order)
values
(:choice_id, :question_id, :trimmed_response, :count)
insert into survey_choice_scores
(choice_id, variable_id, score)
values
(:choice_id, :variable_id, :score)