I have three tables:
- customers for those companies
- addresses for each customer
I want to know how many companies in my database has the accounts with more that 100 addresses linked to them.
I tried this but it didn't work:
Addresses ad ON ad.Customer = cu.Id
Companies c ON cu.company = c.Id
COUNT(ad.ID) > 100