I have a game in which we store user results in a table, similar to this structure:
game_id, user_id, score, ....
Now, our service team would like to find all the game_ids where User A and User B played together. Meaning I want to SELECT and GROUP BY game_ids WHERE an entry to user_id = A and the other entry to user_id = B.
What would be a powerful way to query this in MySQL?