Queries and subqueries in MySQL, show customers with products purchased

[John Bandan]

i have one problem this is my simple diagram:

http://i45.tinypic.com/121c48m.png

Well I tried a lot and I can not do what I need, I need to display a list of customers who have made purchases, with most purchased products in every purchase made, for example

Customer number 1 ---> BUY:

- 4 chicken soups
- 3 meat soups
- 2 shrimp soup

Customer number 2 --->BUY:

- 1 chicken soups
- 1 meat soups
- 2 shrimp soup

Customer number 3 --->BUY:

- 4 chicken soups
- 8 meat soups
- 1 shrimp soup

The result of my query must be:

http://i45.tinypic.com/2ni9w87.png

Please help me make this mysql query correctly