Amazon Business Intelligence Engineer Intern interview questions

A large number of behavioral questions centered around AMZN LPs. In terms of technical questions, there are simple SQL questions and one case study question about whether to have a data center in a new location. There are also questions about data visualization (asking you what are good data via practices, what mistakes people make when they are making data visualization etc).

Write some SQL queries starting from the given tables, and then replicate the queries in Python language.