Question d’entretien chez Meta

Two SQL question about correlation using CTEs and group by functions