-- Database schema
| geographic : city [ TEXT ] primary_key , county [ TEXT ] , region [ TEXT ] | generalinfo : id_restaurant [ INTEGER ] primary_key , label [ TEXT ] , food_type [ TEXT ] , city [ TEXT ] generalinfo.city = geographic.city , review [ REAL ] | location : id_restaurant [ INTEGER ] primary_key location.id_restaurant = generalinfo.id_restaurant , street_num [ INTEGER ] , street_name [ TEXT ] , city [ TEXT ] location.city = geographic.city |
-- -- How many American food restaurants are unpopular in 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' );