sample.sql

WITH pdata AS (
SELECT _PARTITIONDATE AS date, player_id, platform
FROM penguin_jp.person_data
WHERE
  _PARTITIONDATE BETWEEN '2020-06-01' AND '2020-06-11'
)
SELECT _PARTITIONDATE AS date, pdata.platform, SUM(price)
FROM penguin_jp.virtual_coin AS v
JOIN pdata ON pdata.player_id=v.player_id  AND pdata.date = v._PARTITIONDATE
WHERE
  _PARTITIONDATE BETWEEN '2020-06-01' AND '2020-06-10'
GROUP BY 1, 2 ORDER BY 1, 2