Question d’entretien chez TikTok

Given 4 SQL table, get results with basic join / window function