Latest balance
Using account_balances, return each account's latest balance on or before 2026-06-30.
If the same date was loaded more than once, use the most recent load.
output columns
account_idbalance_datebalanceuses
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.