Scotiabank Interview Question

How to deal with data in SQL.