SELECT Count(*) ,  T2.FullName ,  T2.id FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker  =  T2.Id GROUP BY T2.id;
What is the number of car models that are produced by each maker and what is the id and full name of each maker?
SELECT Count ( * ) , T2.FullName , T2.id FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker = T2.Id GROUP BY T2.id ;
select count ( * ) , t2 . fullname , t2 . id from model_list as t1 join car_makers as t2 on t1 . maker = t2 . id group by t2 . id
What is the number of car models that are produced by each maker and what is the id and full name of each maker ?