I am trying to display areas in a select component and am fairly new to Retool. Right now I have a select query "getVisitAreas" like this:
select visit_averages.route_area from visit_averages order by visit_averages.route_area
![chrome_f3SXD57QmU](https://community.retool.com/uploads/default/original/3X/1/e/1e90b8ec02c98c18a5ea7821b59292f51e25df2c.png)
How can I get the value of the query to display? In this case the route_area.
To consider as well, my next step is to do a calculation based on the route_area and its other columns: salt and snow. eg {{ numberInput6.value * select1.value }}.