# Queries using NRQL (New Relic Query Language)

Queries take the general form of:

[![image.png](https://kb.overandunder.au/uploads/images/gallery/2025-06/scaled-1680-/zdZnUpOwa1QwCJoo-image.png)](https://kb.overandunder.au/uploads/images/gallery/2025-06/zdZnUpOwa1QwCJoo-image.png)

`<strong>SELECT </strong>function(attribute) <strong>FROM </strong>Event_Type <strong>FACET </strong>dimension`

- **SELECT** defines the portion of the data you want to query, such as an attribute or a function
- **FROM** defines the type of data to be queried
- **FACET** details how the data will be grouped together

For example, to see the count of errors listed by hostname, you might use:

`<strong>SELECT</strong> count(*) <strong>FROM</strong> Error_Messages <strong>FACET</strong> hostname`

The **SELECT** and **FROM** selectors are required for most queries, the only exception being when you are deleting data using the **DELETE** keyword. All other operators and keywords are optional and depend on the particular query that is being written.

**FUNCTION**s can be grouped into two categories - Aggregator and Non-aggregator

*Aggregator* functions are used to filter and aggregate numerical data. Example: `average`

*Non-aggregator* functions are used for non-numerical data in NRQL such as querying for an account ID or capturing specific attributes. Example: `accountID`

##### Common Event Types By Agent:

<table border="1" id="bkmrk-agent-name-event-typ" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 50%;"></col><col style="width: 50%;"></col></colgroup><tbody><tr><td>**Agent Name**</td><td>**Event Type**</td></tr><tr><td>Browser</td><td>PageView</td></tr><tr><td>Application Performance Management</td><td>Transaction</td></tr><tr><td>Infrastructure</td><td>SystemSample</td></tr><tr><td>Mobile</td><td>MobileRequest</td></tr><tr><td>OpenTelemetry</td><td>Span</td></tr></tbody></table>