select count(*) from countries as t1 join car_makers as t2 on t1.countryid  =  t2.country group by t1.countryid having count(*)  >  2
What is the number of countries with 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 ( * ) > value
What is the number of countries with more than 2 car makers ?