I have a table which tells me the compatibles each user has.
I would like to know what is the average number of compatibles for ALL users.
I tried this:
SELECT AVG( COUNT(*) )
GROUP BY COMPATABILITY_USER_ID
But it returns "Invalid use of Group function".
Is anyone able to comment and fix my mistake ?