Oracle interview question

customer problem and gives solution