Slide 4
Slide 4 text
よくあるランキングの作成方法
①データ抽出 ②集計 ③並び替え
uid user_id product_id price
1 B8SbtiBOANqrwBRZNqBC 77 854
2 UaT3oAhmpQISx2zcXCAa 37 224
3 uK1irdbRRiHiZ8BHpP7o 66 972
4 qUMBtHI26hXJYu7eBfFD 96 454
5 iwq0khAXZl1Jea8wWrx3 40 826
6 e5LLuieSvuq6F811U7OG 15 134
7 kXBqFpOONoo0P0Up4jaz 40 480
8 fMqQUsfgJvY1Nxwf7ZDt 28 578
9 KpR5bzLRQlnOpyi1mgUa 6 210
10 FioKcVD9U46y6dHky2Zr 67 774
product_id price
1 9,715
2 3,628
3 2,655
4 5,163
5 2,719
6 6,722
7 6,082
8 8,210
9 3,565
10 3,968
rank product_id price
1 1 9,715
2 66 9,654
3 20 8,807
4 88 8,351
5 8 8,210
6 28 7,981
7 16 7,770
8 86 7,646
9 40 7,624
10 57 7,194