rr:sqlQuery
| - SELECT REPLACE(Appelation,' ','') as Appelation_URI, Appelation, REPLACE(County, ' ','') as County, REPLACE(State, ' ','') as State, REPLACE(Area, ' ','') as Area, CASE WHEN isAVA = 'Yes' THEN 'true' ELSE 'false' END as isAVA FROM spider.wine.appellations
|