select station_meta.name as "Place",
    an_sun.dec as "December_Sun",
    an_low.jan as "January_Low_Avg",
    an_hi.jul  as "July_Hi_Avg",
    an_hi.jul - an_low.jan as "Temp_Range",
    an_hum.jul as "July_Humidity_Avg"
from allnorms an_sun
join station_meta on an_sun.station = station_meta.station
join allnorms an_low on an_low.station = an_sun.station
join allnorms an_hi  on an_hi.station = an_sun.station
join allnorms an_hum on an_hum.station = an_sun.station
where station_meta.country_name = 'United States Of America'
    and an_sun.clim_elem_code = '15' -- sunshine
    and an_sun.statistic_code = '44' 
    and an_low.clim_elem_code = '03' -- mean low temp (in january)
    and an_low.statistic_code = '01' 
    and an_low.jan > -10             -- no cold places
    and an_hi.clim_elem_code  = '02' -- mean hi temp (in july)
    and an_hi.statistic_code  = '01' 
    and an_hum.clim_elem_code = '11' -- mean humidity (in july)
    and an_hum.statistic_code = '94' 
order by an_sun.dec desc  limit 11;