Jabong.com interview question

Puzzles SQL basics