select * from products where cregion='Anjou' and cprice between 10 and 50 and cstock>1
Anjou French Wine region
Browse Wines by Region
France
: Anjou
Anjou: Anjou's vineyards
lie to the south, and the region produces standard
rosé and very good Chenin Blanc, notably
the complex, long-lived Savenniéres and
wonderful botrysized sweet wines capable of aging,
called Quarts de Chaumes and Bonnezaux, and even
a methode-champenoise sparkling wine from Samur.
