IBM interview question

few basic sql queries