TikTok interview question

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