SELECT Name, Vorname, WohnOrt
FROM Kunden
GROUP BY WohnOrt
HAVING Anzahl <
(SELECT COUNT(* ) AS AnzahlKunden
FROM Kunden
GROUP BY WohnOrt
ORDER BY AnzahlKunden DESC
LIMIT 0,1)
ORDER BY Anzahl DESC[/sourcecode]
SELECT Name, Vorname, WohnOrt
FROM Kunden
GROUP BY WohnOrt
HAVING Anzahl <
(SELECT COUNT(* ) AS AnzahlKunden
FROM Kunden
GROUP BY WohnOrt
ORDER BY AnzahlKunden DESC
LIMIT 0,1)
ORDER BY Anzahl DESC[/sourcecode]