NatWest Group interview question

SQL queries and joins