IBM Interview Question

few basic sql queries