WHERE with boolean-style integer flag
Before I close the month — pull every un-posted journal entry (`posted = 0`). Return `txn_id`, `txn_date`, `account_id`, `amount`, and `description`. I need to chase each one down with the originator.
Each hint you reveal reduces the XP you can earn. Try the query first.
Single table, single filter: `WHERE posted = 0`.
Select the five columns Daniel listed.
No ORDER BY requirement, but `ORDER BY txn_date` makes the review easier.