RetailMeNot interview question

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