Pregunta de entrevista de ARM Insight

SQL coding on SQL which is fine though im not familiar with the syntax as im experienced in oracle which made me check the syntax for some functions using the internet,