Amazon interview question

The Online assessment is divided into two categories... 1. MCQ- Basic Excel Formulas, Basic SQL Queries. 2. 5 SQL problems to be solved without using Windows Functions. You need to be strong in the basics of Nested SQL queries to clear these