SELECT T1.Id ,  T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker GROUP BY T1.Id HAVING count(*)  >=  2 INTERSECT SELECT T1.Id ,  T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker JOIN CAR_NAMES AS T3 ON T2.model  =  T3.model GROUP BY T1.Id HAVING count(*)  >  3;
What are the ids and makers of all car makers that produce at least 2 models and make more than 3 cars?
SELECT T1.Id , T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id HAVING count ( * ) > = 2 INTERSECT SELECT T1.Id , T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker JOIN CAR_NAMES AS T3 ON T2.model = T3.model GROUP BY T1.Id HAVING count ( * ) > 3 ;
select t1 . id , t1 . maker from car_makers as t1 join model_list as t2 on t1 . id = t2 . maker group by t1 . id having count ( * ) > = value intersect select t1 . id , t1 . maker from car_makers as t1 join model_list as t2 on t1 . id = t2 . maker join car_names as t3 on t2 . model = t3 . model group by t1 . id having count ( * ) > value
What are the ids and makers of all car makers that produce at least 2 models and make more than 3 cars ?