ap2さん作成「人を選ぶゲーム」の逆バージョンです。
標準偏差が12以下で、最高点と最低点の差が50以下で、得点の数が10以上のものを抽出しています。
SELECT '<A href="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/game.php?game='||g.id||'">'||g.gamename||'</A><A>'||CASE WHEN g.model='PC' AND g.erogame='f' THEN '(非18禁)' WHEN g.model='PC' THEN '' ELSE '('||g.model||')' END||'</A>' AS ゲーム名, '<A href="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/brand.php?brand='||b.id||'">'||b.brandname||'</A><A>'||CASE WHEN b.kind='CIRCLE' THEN '(同人)' ELSE '' END||'</A>' AS ブランド名, '<A>'||CASE WHEN point91='ボーイズラブ' THEN 'BL' WHEN point91='KineticNovel' THEN 'KN' WHEN point91='育成モノ' THEN '育成' ELSE substr(translate(point91,'(',' '),1,3) END||'</A>' AS ジャンル, '<FONT COLOR="#'||CASE WHEN current_date-g.sellday+1<=180 AND current_date-g.sellday+1>=31 THEN '0000FF' WHEN current_date-g.sellday+1<31 THEN 'FF0000' ELSE '' END||'">' ||to_char(g.sellday, 'YYYY/MM/DD')|| '</FONT>' AS 発売日, g.median AS 中央値, round(point1,2) AS 平均点, round(point3,1) AS 標準偏差, point4 AS 最高点, point5 AS 最低点, '<FONT COLOR="#'||CASE WHEN point2 >=1000 THEN 'FF0000' WHEN point2 < 1000 AND point2 >=500 THEN '0000FF' ELSE '' END||'">' ||point2|| '</FONT>' AS データ数 FROM (SELECT ag.game AS id91, a.title AS point91 FROM attributegroupsboolean ag, attributelist a WHERE ag.attribute=a.id AND a.furigana like '01%' UNION ALL SELECT id AS id91, null FROM (SELECT id, count(id) FROM gamelist GROUP BY id)tb91 LEFT JOIN (SELECT ag.game AS id91, a.title AS point91 FROM attributegroupsboolean ag, attributelist a WHERE ag.attribute=a.id AND a.furigana like '01%')tb92 ON id=id91 WHERE point91 IS NULL ORDER BY id91 DESC)tb93, (SELECT game, AVG(tokuten) AS point1, COUNT(tokuten) AS point2, STDDEV(tokuten) AS point3, MAX(tokuten) AS point4, MIN(tokuten) AS point5 FROM (SELECT game, tokuten FROM userreview UNION ALL SELECT game, tokuten FROM reviewpagelist WHERE tokuten is not null)tb1 GROUP BY game) AS j, gamelist g, brandlist b WHERE j.game = g.id AND id91=g.id AND g.brandname=b.id AND point3 <= '12.0' AND point2 >= 10 AND point4-point5 <= 50 ORDER BY point1 DESC