select * from products where cregion='Emilia-Romagna' and cprice between 10 and 50 and cstock>1
Emilia-Romagna Italian Wine region
Browse Wines by Region
Italy: Emilia-Romagna
This region's most famous wine is Lambrusco. Although most of what is shipped to the U.S. is the sweet, bulk type, the best examples can be excellent. Lambrusco may be frizzante or dry and flavorful, and red and white styles exist made from various red and white grapes of the same name. A notable white DOCG wine also hails from Emilia-Romagna. Called Albana di Romagna DOCG, is has been so classified since 1987. This wine is vinified from the grape of the same name in styles ranging from dry to semi-sweet
