# Query

<figure><img src="https://content.gitbook.com/content/rf0prjfAFgkoPcoDdnqL/blobs/3cHMr9MzjZYtMU5KjSGP/Screen%20Shot%202023-09-13%20at%202.42.17%20AM.png" alt="Pinot Query Console"><figcaption></figcaption></figure>

{% content-ref url="user-guide-query/querying-pinot" %}
[querying-pinot](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/querying-pinot)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-options" %}
[query-options](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-options)
{% endcontent-ref %}

### Explore query syntax:

{% content-ref url="user-guide-query/query-syntax/json-queries" %}
[json-queries](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/json-queries)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/supported-aggregations" %}
[supported-aggregations](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/supported-aggregations)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/how-to-handle-unique-counting" %}
[how-to-handle-unique-counting](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/how-to-handle-unique-counting)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/explain-plan" %}
[explain-plan](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/explain-plan)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/filtering-with-idset" %}
[filtering-with-idset](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/filtering-with-idset)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/gap-fill-functions" %}
[gap-fill-functions](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/gap-fill-functions)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/grouping-algorithm" %}
[grouping-algorithm](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/grouping-algorithm)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/joins" %}
[joins](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/joins)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/joins" %}
[joins](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/joins)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/lookup-udf-join" %}
[lookup-udf-join](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/lookup-udf-join)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/supported-transformations" %}
[supported-transformations](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/supported-transformations)
{% endcontent-ref %}

{% content-ref url="user-guide-query/scalar-functions" %}
[scalar-functions](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/scalar-functions)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/windows-functions" %}
[windows-functions](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/windows-functions)
{% endcontent-ref %}

{% content-ref url="user-guide-query/query-syntax/windows-functions" %}
[windows-functions](https://docs.pinot.apache.org/release-1.1.0/for-users/user-guide-query/query-syntax/windows-functions)
{% endcontent-ref %}