SELECT DISTINCT Winery FROM WINE WHERE Price BETWEEN 50 AND 100
Find the distinct winery of wines having price between 50 and 100.
SELECT DISTINCT Winery FROM WINE WHERE Price BETWEEN 50 AND 100
select distinct winery from wine where price between value and value
Find the distinct winery of wines having price between 50 and 100 .