Skip to content

Instantly share code, notes, and snippets.

@syossan27

syossan27/bq.sql

Created March 27, 2022 05:12
Show Gist options
  • Save syossan27/66efe7bb70840ed824208cfcbd3745e6 to your computer and use it in GitHub Desktop.
Save syossan27/66efe7bb70840ed824208cfcbd3745e6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bq.sql
WITH numbered AS (
SELECT *, ROW_NUMBER() OVER (partition by summary_date order by timestamp desc) as rn
FROM `hoge-project.burndown_chart.day_results`
)
SELECT total_point, done_point, summary_date FROM numbered WHERE rn = 1 order by summary_date asc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment