SELECT
  product,
  value,
  RANK() OVER (PARTITION BY product ORDER BY value DESC) AS ranking,
  NTILE(100) OVER (PARTITION BY product ORDER BY value DESC) AS percentile_rank
FROM
  dataset.table
ORDER BY
  1, 2, 3, 4

この記事が気に入ったら『目黒で働く分析担当の作業メモ』ご支援をお願いします!

※OFUSEに飛びます


おすすめの記事