Wells Fargo Interview Question

SQL related, Testing basic concepts