Berapa volume charge kami bulan lalu?

with monthly_balance_transactions as (
  select
    date_trunc('month', case when type = 'payout' then available_on else created end) as month,
35 lines hidden
from monthly_balance_transactions
where month = date_trunc('month', date '2017-05-01')
order by 1 desc, 2

Berikut laporannya di Sigma! https://dashboard.stripe.com/query/a8491mfu1j

Berapa banyak pelanggan yang kami miliki di Prancis?

select
  id,
  email,
3 lines hidden
  shipping_address_country 
from customers
where shipping_address_country = 'FR'

Saya melihat 783 di Sigma: https://dashboard.stripe.com/query/8jt2d45u1x