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;
Which are the car makers which produce at least 2 models and more than 3 car makers ? List the id and the maker .
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
Which are the car makers which produce at least 2 models and more than 3 car makers ? List the id and the maker .