::: {.cell}

```{.r .cell-code}
DBI::dbGetQuery(# wide reshape 2
  con, '
PIVOT iris_long_i 
USING mean(value) 
AS "." 
GROUP BY Species,part,dim')
```

::: {.cell-output .cell-output-stdout}

```
      Species  part    dim     .
1  versicolor Petal Length 4.260
2  versicolor Petal  Width 1.326
3   virginica Petal Length 5.552
4   virginica Petal  Width 2.026
5      setosa Sepal Length 5.006
6      setosa Sepal  Width 3.428
7      setosa Petal Length 1.462
8      setosa Petal  Width 0.246
9  versicolor Sepal Length 5.936
10  virginica Sepal Length 6.588
11 versicolor Sepal  Width 2.770
12  virginica Sepal  Width 2.974
```


:::
:::