Question

Given a table Transactions(txn_id, account_id, amount, txn_date), which query correctly finds accounts that made more than 3 transactions on the same single day, listing the account and that day's transaction count?

Q: Answer-Given a table Transactions(txn_id, account_id, amount, txn_date), which query correctly finds accoun...

The requirement is more than 3 transactions on the same day, so grouping must be on both accountid and txndate together grouping by accountid alone option C would incorrectly count transactions across all days combined. WHERE cannot filter on an aggregate function like COUNT options A and D are invalid for this reason aggregate filtering requires HAVING, applied after grouping. Option B correctly groups by both columns and filters grouped results with HAVING COUNT 3.