Pergunta de entrevista da empresa LinkedIn

question on self joins, CTE, aggregations, grouping, ranks