select section_id from survey_questions where question_id = :question_id select count(*) from survey_question_responses where question_id = :question_id delete from survey_question_responses where question_id=:question_id delete from survey_question_choices where question_id = :question_id select * from survey_questions where question_id=:question_id update survey_questions set sort_order=sort_order -1 where section_id in ( select section_id from surveys where survey_id=:survey_id) and sort_order > :sort_order