参考データ:おかず得点と得点の関係性の実行結果

このSQLをお気に入りに登録

SQLの説明

それなり…とあまり…に差がない模様

検索結果

おかず得点通常得点中央値データ数
485.023399
380.025027
277.039048
175.091951
-175.084008
-272.056344

実行したSQL

      select 
 ot as おかず得点
 ,round(avg(t),1)  as 通常得点中央値 
 ,round(avg(r1+r2)-1) as データ数
from
(select 
 okazu_tokuten as ot
 ,tokuten as t
 ,row_number() over(partition by okazu_tokuten order by tokuten,id) as r1
 ,row_number() over(partition by okazu_tokuten order by tokuten desc,id desc) as r2
from userreview 
where tokuten is not null 
 and okazu_tokuten>-3
 and game in(select id from gamelist where erogame ='t')
)r
where r1>=r2-1 
 and r1<=r2+1
group by ot
order by ot desc       

表紙
 ひろいん
 egamescape @ gmail.com