WebMD Health interview question

Pretty in-depth SQL questions.