Getting unique purchases before user lockout

The database contains the following schema. It is required to generate a list of unique pairs (user, product id) for all transactions made by users before they were banned. The list should be ordered first by username, then by product identifier.