How many countries has more than 2 car makers ?
select count(*) from countries as t1 join car_makers as t2 on t1.countryid  =  t2.country group by t1.countryid having count(*)  >  2
select count(*) from countries as t1 join car_makers as t2 on t1.countryid  =  t2.country group by t1.countryid having count(*)  >  2
[{'count(*)': 4}, {'count(*)': 4}, {'count(*)': 3}, {'count(*)': 5}]