Table: fire_sprinkler_specs
Columns: maximum_ceiling_temperature
temperature_rating
temperature_classification
color_code_with_fusible_link
glass_bulb_color

Question: What is the temperature classification of a purple colored glass bulb?
SQL: SELECT "temperature_classification" FROM fire_sprinkler_specs WHERE "glass_bulb_color" = 'purple'

Question: What is the color code with a temperature classification of ordinary?
SQL: SELECT "color_code_with_fusible_link" FROM fire_sprinkler_specs WHERE "temperature_classification" = 'ordinary'

Question: What is the temperature rating of the intermediate temperature classification?
SQL: SELECT "temperature_rating" FROM fire_sprinkler_specs WHERE "temperature_classification" = 'intermediate'