Reset your password

Enter your work email and we will send you a link to choose a new password.

Remembered it? Sign in

Read-only access · masked personal data · every query audited

Question

How did revenue move over the last three months?

select date_trunc('month', paid_at) as month,
       sum(amount) / 1e6 as revenue_kes_m
from payments
where paid_at >= now() - interval '3 months'
group by 1 order by 1

Month	Revenue, KES m
December	15.8
January	17.2
February	18.9

Source: payments · 3 rows · read-only through DBX · sample figures

Every answer shows the SQL that produced it and where the numbers came from.