Assign value based on table and ID
WITH cte AS ( SELECT PolicyID,
                     PolicylocationID,
                     Country,
                     COUNT(CASE WHEN Country = 'US' THEN 1 END) OVER (PARTITION BY PolicyID) us,
                     COUNT(Country) OVER (PARTITION BY PolicyID) total
              FROM test
            )
SELECT PolicyID,
       PolicylocationID,
       Country,
       CASE WHEN us = total THEN 'US'
            WHEN us = 0     THEN 'International'
            ELSE 'Global'
       END CType 
FROM cte


fiddle