Task: Text to Code
Input (English): Step 1: For each row in car_makers table, find the corresponding rows in model_list table.
Step 2: for each value of Id in the results of step 1, find the number of rows along with ModelId and FullName
Output (English): SELECT T2.ModelId , T1.FullName , Count ( * ) FROM car_makers AS T1 JOIN model_list AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id