I am having trouble writing a query and need some help.
I have a table that has a list of addresses. The addresses can be duplicated based on other criteria.
What I need to achieve is to write a query that gives me the Average number of times each address appears in the table, and I'm totally stuck.
Any help would be much appreciated,