CREATE TABLE wine (no DECIMAL, grape TEXT, winery TEXT, appelation TEXT, state TEXT, name TEXT, year DECIMAL, price DECIMAL, score DECIMAL, cases DECIMAL, drink TEXT)
CREATE TABLE grapes (id DECIMAL, grape TEXT, color TEXT)
CREATE TABLE appellations (no DECIMAL, appelation TEXT, county TEXT, state TEXT, area TEXT, isava TEXT)

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" <= 100 AND "price" >= 50