select * from products where cregion='Provence & Corsica' and cprice between 10 and 50 and cstock>1
Provence & Corsica French Wine region
Browse Wines by Region
France
: Provence & Corsica
Provence & Corsica:
Good producers striving for quality can be found
in these areas which tend to be known more for
tourism than fine winemaking. Look for appellations
such as Cassis, Bandol, Coteaux-d'Aix-en-Provence,
Cotes de Provence and Les Baux-de-Provence. On
Corsica, good individual ACs include Patrimonio
and Cateaux du Cap Corse.