How many American food restaurants are unpopular in Carmel?
American Food Restaurant refers to food_type = 'ameraican'; unpopular refers to min(review); Carmel refers to city = 'Carmel'
SELECT COUNT(id_restaurant) FROM generalinfo WHERE food_type = 'american' AND city = 'carmel' AND review = ( SELECT MIN(review) FROM generalinfo WHERE food_type = 'american' AND city = 'carmel' )
database name:db_id restaurant
geographic table geographic Cols: city dtype text, country dtype text, region dtype text, 
generalinfo table generalinfo Cols: id restaurant dtype integer, label dtype text, food type dtype text, city dtype text, review dtype real, 
location table location Cols: id restaurant dtype integer, street number dtype integer, street name dtype text, city dtype text, 
