---
schema_version: "1"
id: 0afc0ef3ed4fb3d8ae5d3960581c5a002fad03beff5db579b1d608db91fb9658
title: SQL Operators for Insights
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_calculated_insights_operators.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_calculated_insights_operators.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 846f30dd358562ee8fc77dba9dad4017a9173850f8a77ff64cb2d6b44eaad251
description: Use these arithmetic, currency, and logical operators in SQL expressions when you author calculated insights in Data 360.
products:
  - Data 360
release: "264"
---
# SQL Operators for Insights

Use these arithmetic, currency, and logical operators in SQL expressions when you author calculated insights in Data 360.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>All Editions</strong> supported by Data 360. See <a href="https://help.salesforce.com/s/articleView?id=data.c360_a_dc_editions.htm&amp;language=en_US" target="_blank">Data 360 edition availability</a>.</td></tr></tbody></table>

## Arithmetic Operators

Use these operators to perform arithmetic operations on numeric operands.

| Operator | Description | Supported Data Types |
| --- | --- | --- |
| `*` | Multiply | Number, Integer, Percent, Currency |
| `+` | Add | Number, Integer, Percent, Currency |
| `-` | Subtract | Number, Integer, Percent, Currency |
| `/` | Divide | Number, Integer, Percent, Currency |

## Currency Operator

| Operator | Description | Supported Data Types |
| --- | --- | --- |
| `TRY_CONVERT_CURRENCY` | Converts aggregate currency values into a single currency value. | Currency |

## Logical Operators

Use these logical operators to combine one or more true or false values. Each operator returns a true or false value.

| Operation | Operator | Supported Data Types |
| --- | --- | --- |
| Not equal to | `!= , <>` | Text, URL, Email, Phone, Number, Percent, Date, DateTime |
| Less than | `<` | Number, Percent, Date, DateTime |
| Less than or equal to | `<=` | Number, Percent, Date, DateTime |
| Equal to | `=` | Text, URL, Email, Phone, Number, Percent, Date, DateTime |
| Greater than | `>` | Number, Percent, Date, DateTime |
| Greater than or equal to | `>=` | Number, Percent, Date, DateTime |
| And | `and` | Text, URL, Email, Phone, Number, Percent, Date, DateTime, Boolean |
| Pattern match | `LIKE; %` | Text, URL, Email, Phone |
| Regular expression match | `RLIKE` | Text, URL, Email, Phone |
| Boolean evaluation | `Is_True, Is_False, Has_Boolean_Value, Has_No_Boolean_Value` | Boolean |

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_example.png)

Example

This example uses logical operators to find individuals who spent more than $5, have a tax rate of 9 or less, an adjusted tax amount of 0, and have orders with a list price other than $100.

```sql
SELECT
SUM(SALESORDER__dlm.grand_total_amount__c) as TotalOrderAmount__c,
Individual__dlm.Id__c as CustomerId__c
FROM SALESORDER__dlm
LEFT JOIN Individual__dlm ON SALESORDER__dlm.partyid__c = Individual__dlm.Id__c
WHERE SALESORDER__dlm.grand_total_amount__c > 5
  and SALESORDER__dlm.tax_rate__c <= 9
  and SALESORDER__dlm.total_adjustment_tax_amount__c = 0
  and SALESORDER__dlm.list_price__c != 100
GROUP BY CustomerId__c
```