fanza4つのまとめ買いの違いの実行結果

SQLの説明

違うところだけ表示。

検索結果

実行したSQL

      select s as
まとめ買い
,median 中央値,count2 データ数,
'<A href="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/game.php?game='||game||'" target="_blank">'|| gamename||'</A>
' ゲーム名 from
(select game,count(c),min(c),max(c) 
,string_agg(case when c=8368 then '20本'
when c=8371 then '10本'
when c=8374 then '5本'
when c=8377 then '3本'
else 'エラー' end
,',' order by c desc) as s
from
(select game,campaign as c from campaign_game
where campaign in (8368,8371,8374,8377
))t
group by game)t2,gamelist g
where count<4 and game=g.id
order by -median,-count2,まとめ買い