How do I query for fields that have AT LEAST a given range?
To find those with a "range" of at least 4 for example

SELECT "Key"
FROM   YourTable
GROUP  BY "Key"
HAVING (1 + MAX("Value") - MIN ("Value")) &gt;= 4; 


Obviously alter the 4 as appropriate for the other cases.

SQL Fiddle