Encore Capital Group interview question

Some basics and advanced level sql and BI questions.