SELECT COUNT(*),city FROM accidents GROUP BY city HAVING COUNT(*)<40 ORDER BY COUNT(*) DESC;
It shows me the cities which are shown under 40 times. But I want to count how many cities there are. So how can I do this with subquery? Please Help me.
SELECT COUNT(*),city FROM accidents GROUP BY city HAVING COUNT(*)<40 ORDER BY COUNT(*) DESC;
It shows me the cities which are shown under 40 times. But I want to count how many cities there are. So how can I do this with subquery? Please Help me.
18 People are following this question.