select * from products where cregion='jerez' and cprice between 10 and 50 and cstock>1
jerez Spain Wine region
Browse Wines by Region
Spain : Jerez
Adjacent to the Strait of Gibraltar in Spain's far south, the three
centers of Jerez (sherry) production are located within a ten mile
triangle along the western coast: Jerez de la Frontera, Sanlucar de Barrameda, and Puerto de Santa Maria. Atlantic breezes offer a moderating influence to the warm Mediterranean climate, lending the wines various almond, salty and olive aromas depending on their microclimates. The prized albariza soil which seems crucial for the Palomino grape is mostly found around the city of Jerez de la Frontera, and the majority of vineyards designated Jerez Superior are near this city, with other parcels occurring in Sanl��car de Barrameda, Puerto de Santa Maria, Chipiona and Rota. The current total vineyard area, much reduced from the past, is under 32,000 acres, predominantly planted with white Palomino and small amounts of Pedro Ximinez and Moscatel.
