CREATE TABLE `cosmonauts` (
  `CosmonautName` varchar( 100 ) NOT NULL default '',
  `BirthDate` datetime default NULL,
  `Country` varchar( 100 ) default NULL,
  `Sex` int( 11 ) default NULL,
  `CosmonautType` varchar( 100 ) default NULL,
  PRIMARY KEY  (`CosmonautName`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251

 SELECT
 a.`CosmonautType`,
 a.`Country`,
 count( 1 ) as cnt
from
 `cosmonauts` a
group by
  1 , 2 
having
 cnt >= (
    select count( 1 ) as cnt_x from `cosmonauts` b where a.cosmonauttype = b.cosmonauttype group by b.country  order by  1  desc limit  0 , 1 
 )

 SELECT
 a.`CosmonautType`,
 a.`Country`,
 count( 1 ) as cnt
from
 `cosmonauts` a
group by
  1 , 2 
having
 cnt >= all (
    select count( 1 ) as cnt_x from `cosmonauts` b where a.cosmonauttype = b.cosmonauttype group by b.country  
 )