From Failing SQL Interviews to Getting 4 Jobs!

My first Amazon interview. (Business Intelligence Engineer role ). 2020 January.

The technical round had 1 SQL question. Write a query to find the top three cities by profit for each country. I knew Select. I knew Group By. I had done joins before, but I had never used window functions. I didn’t know rank or dense rank even existed.

I tried to solve it …