Consulta sobre consultas

[alexg88]

Aunque parece una consulta fácil, no es tan sencillo implementarla.

Te dejo una posible forma:

Código SQL:

SELECT city
FROM (SELECT COUNT(*) AS total, city  
FROM br_user
GROUP BY city) AS temp INNER JOIN
(SELECT MAX(total) AS maximo
FROM
(SELECT COUNT(*) AS total, city  
FROM br_user
GROUP BY city) AS temp2) AS temp3
ON temp3.maximo = temp.total
 

o así

Código SQL:

SELECT city
FROM
(SELECT COUNT(*) AS total, city  
FROM br_user
GROUP BY city) AS temp 
WHERE total =
(SELECT MAX(total) AS maximo
FROM
(SELECT COUNT(*) AS total, city  
FROM br_user
GROUP BY city) AS temp2)