SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA

Deleted all those Duplicate records