select * from products where cregion='Navarra' and cprice between 10 and 50 and cstock>1
Navarra Spain Wine region
Browse Wines by Region
Spain : Navarra
The Navarra region borders Rioja to the northeast and southwest. It has traditionally been known for dry roses, but is now exporting a number of slightly lighter Rioja-style wines at more moderate prices. Red varietals include Tempranillo, Garnacha, Cabernet Sauvignon and Merlot. Whites are the traditional Viura newly supplemented by Chardonnay.
