what exterior color has [1] clear coat?
(AND automotive.exterior_color (JOIN automotive.exterior_color.clear_coat 1^^http://www.w3.org/2001/XMLSchema#integer))