select city, colour
from t as t
group by city, colour
having count(*) = (select top (1) count(*)
                   from t as t2
                   where t2.city = t.city
                   group by t2.colour
                   order by count(*) desc, t2.colour
                  );