All pastes #1759089 Raw Edit

Mine

public sql v1 · immutable
#1759089 ·published 2010-01-20 16:28 UTC
rendered paste body
SELECT phrase, CAST(((amount/CAST((SELECT SUM(amount)/COUNT(*) FROM searches) AS float))+1 - amount/(SELECT SUM(amount)/COUNT(*) FROM searches))*100 AS int) AS y FROM searches GROUP BY phrase, amountHAVING amount > (SELECT SUM(amount)/COUNT(*) FROM searches) ORDER BY phrase ASC LIMIT 30