Innotech (Russia) interview question

SQL, Algoritms, Spring Patterns, DB Indexes, Joins