Pregunta de entrevista de Medi Assist Insurance TPA

SQL questions on join, sub query, rank, partition etc