Temenos interview question

Query to create a table and perform data manipulations