For AI agents: visit https://geekswithlatitude.readme.io/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI.

SELECT unique_key, COUNT(unique_key) AS NumOccurrences
FROM table
GROUP BY uprn
HAVING ( COUNT(unique_key) > 1 );