IBM Interview Question

One SQL, one coding question