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(*)  >=  1;
[{'CountryName': 'usa', 'CountryId': 1}, {'CountryName': 'germany', 'CountryId': 2}, {'CountryName': 'france', 'CountryId': 3}, {'CountryName': 'japan', 'CountryId': 4}, {'CountryName': 'italy', 'CountryId': 5}, {'CountryName': 'sweden', 'CountryId': 6}, {'CountryName': 'uk', 'CountryId': 7}, {'CountryName': 'korea', 'CountryId': 8}]