3 SQL 1 Python , a lot of data warehouse problem and 1 behavior question. 1 hour

1. pretty simple, group by having
2. deep dive, but i think i didn't get correct answer
3. leetcode hard question like find list of top 10 customer_id revenue
4. asked about designing a dimensional table, SCD, Explain analysis of your query, how to optimize your queries
5. Amazon BQ: how to solve a tech problem when you work in a team?
6. 4. file, content into a folder python, this is the one i don't get it. he said he want to group those files and each big folder has same categories files. and he gived me weird files and names. I don't know what the hell he asked me to do.