X-Analytic interview question

Basics from data analytics, python and SQL