Temenos Interview Question

Query to create a table and perform data manipulations