Hi Michael, thank you very much for your prompt answer.
What I want to achieve is, counting the number of distinct items, grouped by user_name Given Item1: item_id = 1 service_id = 'test' item_class = 'dummy' Item2: item_id = 2 service_id = 'other' item_class = 'dummy' Invoice1: id = 1 user_name = 'lorem' item = Item1 Invoice2: id = 2 user_name = 'lorem' item = Item1 Invoice3: id = 3 user_name = 'ipsum' item = Item1 Invoice4: id = 4 user_name = 'ipsum' item = Item2 the expected result is: user: lorem, distinct item count : 1 user: ipsum, distinct item count : 2 -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.