How many car models are produced by each maker ? Only list the count and the maker full name .
create table model_list (maker varchar, PRIMARY KEY (maker)); create table car_makers (fullname varchar, id varchar, PRIMARY KEY (fullname))
select count(*), t2.fullname from model_list as t1 join car_makers as t2 on t1.maker = t2.id group by t2.id