Database: car_1
Question: How many car models are produced by each maker ? Only list the count and the maker full name .
SQL:
select count(*) ,  t2.fullname from model_list as t1 join car_makers as t2 on t1.maker  =  t2.id group by t2.id;