Fidelity Investments Interview Question

Second Round: Panel: SQL question, lots of scenario based question