Thank you to much! I was useful for me too! but one question more: for each "Location", how i can get the "Book" with max "count"? Ex: Location Book Count ------------- -------- ---------- NYC Book5 3 Boston Book5 32 Dallas Book5 13 ... View more