Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM car_makers WHERE Country = "usa"
Feedback: Switch country with country name .
Output (English): SELECT count(*) FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker  =  T2.Id JOIN COUNTRIES AS T3 ON T2.Country  =  T3.CountryId WHERE T3.CountryName  =  'usa'