IBM interview question

One SQL, one coding question