home / russian-ads

russian-ads

Custom SQL query returning 2 rows

select
    spend_currency, sum(spend_usd), sum(spend_amount),
    count(*) as num_ads
from display_ads
group by spend_currency

spend_currencysum(spend_usd)sum(spend_amount)num_ads
RUB 93160.87871999937 5822554.919999996 2533
USD 109.33 109.33 965
Powered by Datasette · Query took 289.541ms