Barclays interview question

Email reply based on the data given.