Review the following Operator reference information to help you create accurate SQL code for your segment attribute conditions.

equal to

Use the equal to operator when you want to include profiles that are exactly equal to the selected value.

...

select count(*) from (
select
a."cdp_customer_id"
from "cdp_audience_1249"."customers" a
where a."gender" = 'Female'
-- set session distributed_join = 'true'
) cs

not equal to

Use the not equal to operator when you want to include profiles that are not equal to the selected value.

Example

Match all profiles in which the gender is not Male.

SQL Example

select count(*) from (
select
a."cdp_customer_id"
from "cdp_audience_1249"."customers" a
where not coalesce(a."gender" = 'Male', false)
-- set session distributed_join = 'true'
) cs

...