Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM car_makers WHERE Country = "france"
Feedback: Use corresponding countries's country name instead of country .
Output (English): SELECT count(*) FROM CAR_MAKERS AS T1 JOIN COUNTRIES AS T2 ON T1.Country  =  T2.CountryId WHERE T2.CountryName  =  'france'