Top 10 vendors — YTD spend

select lower(trim(vendor_name)) as vendor_name, sum(amount) as total_spend
from fact_transactions as ft
JOIN dim_vendors as dv
 ON dv.vendor_id = ft.vendor_id
WHERE ft.posted_date between '2024-01-01' and '2024-12-31'
GROUP BY lower(trim(vendor_name))
ORDER BY total_spend DESC
Limit 10;