HSBC interview question

Find the errors in a particular code. Write SQL Query for particular constraints. Asked about projects.