What is the number of car models that are produced by each maker and what is the id and full name of each maker?
create table car_makers (fullname varchar, id varchar, id varchar, PRIMARY KEY (fullname)); create table model_list (maker varchar, PRIMARY KEY (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