ARM Insight interview question

SQL questions on transactions data set