State Street interview question

SQL topics such as joins.