SELECT present.day, present.low, (MIN(future.day)-present.day) as
days2fall FROM history AS present JOIN history AS future ON ( present.day < future.day AND future.low <= present.low ) GROUP BY present.day,present.low ORDER BY days2fall DESC
-- William Leite Araújo Analista de Banco de Dados - QualiConsult