# Query

<figure><img src="https://content.gitbook.com/content/gYpmZ5dnYUh7aQjLUJ9b/blobs/qhcdGlx7ssDcb1r7luqQ/Screen%20Shot%202023-09-13%20at%202.42.17%20AM.png" alt=""><figcaption></figcaption></figure>

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

{% content-ref url="<https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/query-execution-controls/query-options>" %}
[Query Options](https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/query-execution-controls/query-options)
{% endcontent-ref %}

### Explore query syntax:

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

{% content-ref url="<https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/functions/aggregation>" %}
[Aggregation Functions](https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/functions/aggregation)
{% endcontent-ref %}

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

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

{% content-ref url="<https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/sql-syntax/filtering-with-idset>" %}
[Filtering with IdSet](https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/sql-syntax/filtering-with-idset)
{% endcontent-ref %}

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

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

{% content-ref url="<https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/sql-syntax/joins>" %}
[JOINs](https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/build-with-pinot/querying-and-sql/sql-syntax/joins)
{% endcontent-ref %}

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

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

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

{% content-ref url="<https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/functions/window>" %}
[Window Functions](https://app.gitbook.com/s/-LtH6nl58DdnZnelPdTc-887967055/functions/window)
{% endcontent-ref %}