Pregunta de entrevista de Iron Mountain

SQL questions and scripts basically for logical related merge, case statement