SELECT T1.FullName ,  T1.Id ,  count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker GROUP BY T1.Id;
What is the full name of each car maker, along with its id and how many models it produces?
SELECT T1.FullName , T1.Id , count ( * ) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id ;
select t1 . fullname , t1 . id , count ( * ) from car_makers as t1 join model_list as t2 on t1 . id = t2 . maker group by t1 . id
What is the full name of each car maker , along with its id and how many models it produces ?