SELECT T1.CountryName ,  T1.CountryId FROM COUNTRIES AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId  =  T2.Country GROUP BY T1.CountryId HAVING count(*)  >=  1;
What are the countries having at least one car maker? List name and id.
SELECT T1.CountryName , T1.CountryId FROM COUNTRIES AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId = T2.Country GROUP BY T1.CountryId HAVING count ( * ) > = 1 ;
select t1 . countryname , t1 . countryid from countries as t1 join car_makers as t2 on t1 . countryid = t2 . country group by t1 . countryid having count ( * ) > = value
What are the countries having at least one car maker ? List name and id .