Scotiabank Interview Question

What does this SQL command do?