---
title: "SQL"
output: github_document
vignette: |
  %\VignetteIndexEntry{SQL}
  %\VignetteEngine{knitr::rmarkdown}
  %\VignetteEncoding{UTF-8}
---

Script:

```
namespace <- "yournamespace"

ans <- execute_sql_query(
  query="select `rows`, AVG(a) as avg_a from `tiledb://TileDB-Inc/quickstart_dense` GROUP BY `rows`",
  name="rows-query",
  namespace=namespace)
show(ans)

ans <- execute_sql_query(
  query="select `rows`, AVG(a) as avg_a from `tiledb://TileDB-Inc/oops_a_typo` GROUP BY `rows`",
  name="rows-query",
  namespace=namespace)
show(ans)
```

Output:

```
    avg_a rows
1  2.5000    1
2  6.5000    2
3 10.5000    3
4 14.5000    4

Error: tiledbcloud: received error response: Server returned 400 response status code.
Message:  Error 1146: Table 'test.tiledb://TileDB-Inc/oops_a_typo' doesn't exist
Execution halted
```
