# Workflow$query

### Workflow$<mark style="color:purple;">query</mark>(*query\_string*) → [Query](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

Execute a SQL query scoped to a workflow. Table names do not need to be fully qualified, since all tables are assumed to be within the workflow.

### **Parameters:**

**`query_string` :&#x20;*****str*** \
The SQL query to execute. Must follow the [Redivis SQL query syntax](https://docs.redivis.com/reference/projects/transform-nodes/raw-sql).

### **Returns:**

[**Query**](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

### Examples

<pre class="language-r"><code class="lang-r">workflow &#x3C;- redivis$user("imathews")$workflow("example_workflow_climate_analysis")

# The query can reference any table in the workflow
query &#x3C;- workflow$query("
    SELECT
        id,
<strong>        EXTRACT(YEAR FROM date) AS year,
</strong>        SUM(value) AS annual_precip
    FROM daily_observations
    WHERE (element = 'PRCP')
    GROUP BY id, year
")
query$to_tibble()
# 	id	        year	    annual_precip
# 0	CA0023026HN	2003	    2925.0
# ...
</code></pre>