User:TweetsFactsAndQueries/Queries/US governors by eye color

Originally posted on Twitter and on Mastodon.

# US governors by eye color
#defaultView:Map{ "hide": ["?rgb", "?shape"] }
SELECT ?state ?stateLabel ?governor ?governorLabel ?eyeColor ?eyeColorLabel (?eyeColorRgb AS ?rgb) ?shape
WITH {
  SELECT ?eyeColor (SAMPLE(?eyeColorRgb) AS ?eyeColorRgb) WHERE {
    [] wdt:P1340 ?eyeColor.
    OPTIONAL { ?eyeColor wdt:P465 ?eyeColorDirectRgb. }
    OPTIONAL { ?eyeColor wdt:P462/wdt:P465 ?eyeColorIndirectRgb. }
    BIND(COALESCE(?eyeColorDirectRgb, ?eyeColorIndirectRgb) AS ?eyeColorRgb)
  }
  GROUP BY ?eyeColor
} AS %eyeColorsRgb
WHERE {
  ?state wdt:P31 wd:Q35657;
         wdt:P6 ?governor;
         wdt:P3896 ?shape.
  ?governor wdt:P31 wd:Q5;
            wdt:P1340 ?eyeColor.
  INCLUDE %eyeColorsRgb.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!