June transaction count
For every account in accounts, return how many transactions it had in June 2026.
Accounts with no June transactions must show 0.
output columns
account_idjune_txn_countuses ,
ctrl + enter to run on the sample data · ctrl + shift + enter to submit
run your query to see the output here. Submit checks it against the sample data, hidden test cases, random data and a large dataset.