View latest transactions with specific payment method

[SilasPeters]

The Commisioner(?) of Internal Affairs requested me to perform the following query:

SELECT checkout_transactions.price Prijs, checkout_transactions.updated_at Datum
FROM checkout_transactions
JOIN checkout_balances ON checkout_transactions.checkout_balance_id=checkout_balances.id
WHERE checkout_transactions.created_at > '2023-08-01' AND payment_method = 'Verkoop'

He also requested a similar query, where payment_method IS NULL (instead of payment_method = 'Verkoop'

I asked if he would like this to be a feature of Magnificent Sloth, and he said yes. This needs to be done every year.

Thus, this issue requests to be able to put this query behind a button or a nice overview, where you can select which year to inspect.