Pregunta de entrevista de Meta

Two SQL question about correlation using CTEs and group by functions