SELECT
    entity_id_l, entity_id_r,
    CASE WHEN name_l = name_r THEN 1 ELSE 0 END AS exact_match,
    jaro_winkler_similarity(name_l, name_r) AS jaro_winkler_sim,
    CASE WHEN country_l = country_r THEN 1 ELSE 0 END AS same_country
FROM candidate_pairs