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;
[{'FullName': 'American Motor Company', 'Id': 1, 'count(*)': 1}, {'FullName': 'Volkswagen', 'Id': 2, 'count(*)': 2}, {'FullName': 'BMW', 'Id': 3, 'count(*)': 1}, {'FullName': 'General Motors', 'Id': 4, 'count(*)': 5}, {'FullName': 'Ford Motor Company', 'Id': 5, 'count(*)': 3}, {'FullName': 'Chrysler', 'Id': 6, 'count(*)': 4}, {'FullName': 'Citroen', 'Id': 7, 'count(*)': 1}, {'FullName': 'Nissan Motors', 'Id': 8, 'count(*)': 2}, {'FullName': 'Fiat', 'Id': 9, 'count(*)': 1}, {'FullName': 'Honda', 'Id': 11, 'count(*)': 1}, {'FullName': 'Mazda', 'Id': 12, 'count(*)': 1}, {'FullName': 'Daimler Benz', 'Id': 13, 'count(*)': 2}, {'FullName': 'Opel', 'Id': 14, 'count(*)': 1}, {'FullName': 'Peugeaut', 'Id': 15, 'count(*)': 1}, {'FullName': 'Renault', 'Id': 16, 'count(*)': 1}, {'FullName': 'Saab', 'Id': 17, 'count(*)': 1}, {'FullName': 'Subaru', 'Id': 18, 'count(*)': 1}, {'FullName': 'Toyota', 'Id': 19, 'count(*)': 2}, {'FullName': 'Triumph', 'Id': 20, 'count(*)': 1}, {'FullName': 'Volvo', 'Id': 21, 'count(*)': 1}, {'FullName': 'Kia Motors', 'Id': 22, 'count(*)': 1}, {'FullName': 'Hyundai', 'Id': 23, 'count(*)': 1}]