Akamai Interview Question

write the sql query to show the customer purchase details given the relation structure