Just for fun: Now using BigQuery to import my credit card bills and analyze them, lol. (And the higest went to Uber Eats with no competition…)
SELECT shop, FORMAT_DATE('%Y-%m', date) ym, SUM(amount) as `count` FROM `credit_csvs.utf-8` GROUP BY ym, shop ORDER BY count DESC
Replacing my Python analyzing script so I can just focus on adding more complex queries for future uses.