-- Database schema
| continents : ContId [ INT ] primary_key , Continent [ TEXT ] | countries : CountryId [ INT ] primary_key , CountryName [ TEXT ] , Continent [ INT ] countries.Continent = continents.ContId | car_makers : Id [ INT ] primary_key , Maker [ TEXT ] , FullName [ TEXT ] , Country [ TEXT ] car_makers.Country = countries.CountryId | model_list : ModelId [ INT ] primary_key , Maker [ INT ] model_list.Maker = car_makers.Id , Model [ TEXT ] | car_names : MakeId [ INT ] primary_key , Model [ TEXT ] car_names.Model = model_list.Model , Make [ TEXT ] | cars_data : Id [ INT ] primary_key cars_data.Id = car_names.MakeId , MPG [ TEXT ] , Cylinders [ INT ] , Edispl [ INT ] , Horsepower [ TEXT ] , Weight [ INT ] , Accelerate [ INT ] , Year [ INT ] |
-- -- Which countries in europe have at least 3 car manufacturers?

SELECT T1.CountryName FROM COUNTRIES AS T1 JOIN CONTINENTS AS T2 ON T1.Continent  =  T2.ContId JOIN CAR_MAKERS AS T3 ON T1.CountryId  =  T3.Country WHERE T2.Continent  =  'europe' GROUP BY T1.CountryName HAVING count(*)  >=  3;