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 = :section_id and sort_order > :sort_order