Akamai interview question

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