SELECT account_id
FROM account JOIN transactions
ON account.id = transaction account_id
GROUP BY account_id
HAVING COUNT (transaction game.id)>10;
SELECT tr.account_id , ac.first_name, ac.last_name, ac.birth_name
FROM transaction as tr
LEFT JOIN account as ac ON ac.id = tr.account_id
GROUP BY tr.account_id
HAVING COUNT (tr.account_id) >= 10;