Query simplification Oracle Northwind

Question

Task :

Find country to which maximum of customers belong.

Query

SELECT country,
       count(*)
FROM customers
GROUP BY country
HAVING count(*) =
  (SELECT max(max_sal)
   FROM
     (SELECT count(*) max_sal
      FROM customers
      GROUP BY country)) ;

Result:

The Result is correct but i think it is difficult way to write query

Question : Is there any simple way to rewrite this query.

Answer 1

I might be missing something, but it can be as simple as this:

SELECT *
  FROM (  SELECT country, COUNT (*) max_sal
            FROM customers
        GROUP BY country
        ORDER BY COUNT (*) DESC)
 WHERE ROWNUM <= 1;