ELECT
      id,
      prefix,
      first_value(prefix) OVER (
        PARTITION BY host
        ORDER BY 9