Yandex interview question

What SQL queries did you make, describe them