Windows8で複数のユーザーに動作確認されたゲーム。(中央値はW8以外含む)
select sellday as 発売日, '<a href = "game_support_platform.php?game=' || game_id || '" target="_blank">' || gamename || '</a>' as タイトル ,median as 中央値,tb.count as W8ユーザー数 from toukei_temp_table t,(select game,count(*) from support_platform where platform=8 and operation=1 group by game)tb
where game_id=game and tb.count>1 order by sellday desc