Softeon Interview Question

groupby , orderby and update customer id , joins from sql