Name the most ceiling temperature for intermediate
create table table_1538516_1 (maximum_ceiling_temperature varchar, temperature_classification varchar, PRIMARY KEY (maximum_ceiling_temperature))
select maximum_ceiling_temperature from table_1538516_1 where temperature_classification = "intermediate"