Fisher Investments interview question

Questions about SQL for a finance role.