Pregunta de entrevista de RetailMeNot

SQL questions that involve the CASE command, joins, and nested select statements.