the human has a question about Ecomm Users.  Here is a list of fields which can be used with your tools:
 user_details.age is a number and is detail field
The user's age from their profile creation

"California" is a value in the database field user_details.state for at least 20289 Ecomm Users 
"California" is a value in the database field web_events.state for at least 20289 Ecomm Users 
"THI" is a value in the database field user_details.first_name for at least 1 Ecomm Users 
user_facts.lifetime_orders is a number and is detail field
The number of orders this user has placed over the course of being a customer

order_items.created_at is a date and is not a detail field
The date that the item was placed by the customer

web_events.uri is a str and is not a detail field
The url the user came from

user_facts.last_order_date is a date and is detail field
The users last order date

user_facts.first_order_date is a date and is detail field
The users first order date

order_items.order_id is a number and is not a detail field

inventory_items.user_id is a number and is not a detail field

products.user_id is a number and is not a detail field

'Aging New Users Without Orders' is a subset of Ecomm Users with id: 7
'Low Value Users (removing new users and inactive users)' is a subset of Ecomm Users with id: 10
'New Users' is a subset of Ecomm Users with id: 6
'Users from Order Items Source' is a subset of Ecomm Users with id: 1
'Users from User Facts Source' is a subset of Ecomm Users with id: 2
'Users from User Details Source' is a subset of Ecomm Users with id: 3
'Users from Web Events Source' is a subset of Ecomm Users with id: 4
'Users from Ordered Product Source' is a subset of Ecomm Users with id: 5
'Users with Returns (90 days)' is a subset of Ecomm Users with id: 9
'New Users Ordered Sequence' is a subset of Ecomm Users with id: 12
source order_items can be filtered with fields in sources order_items, inventory_items, products.
source user_facts can be filtered with fields in sources user_facts.
source user_details can be filtered with fields in sources user_details.
source web_events can be filtered with fields in sources web_events.
source inventory_items can be filtered with fields in sources order_items, inventory_items, products.
source products can be filtered with fields in sources order_items, inventory_items, products.


```subset_expression
{"symbols": {"B": {"value": {"value": 1, "filters": [{"value": {"value": "year"}, "operator": "this", "field": "order_items.created_at"}], "operator": "greater than or equal to"}, "operator": "count", "field": "order_items.user_id"}, "C": {"value": {"value": ["California"]}, "operator": "equals", "field": "user_details.state"}, "D": {"value": {"desc": true, "value": "12", "function": "average", "operator": "less than or equal to"}, "operator": "top n", "field": "user_details.age"}}, "expression": "!B>C>D", "population": "Ecomm Users"}
```
<s>[INST] <<SYS>>
the human has a question about Ecomm Users.  Here is a list of fields which can be used with your tools:
 user_details.age is a number and is detail field
The user's age from their profile creation

"California" is a value in the database field user_details.state for at least 20289 Ecomm Users 
"California" is a value in the database field web_events.state for at least 20289 Ecomm Users 
"THI" is a value in the database field user_details.first_name for at least 1 Ecomm Users 
user_facts.lifetime_orders is a number and is detail field
The number of orders this user has placed over the course of being a customer

order_items.created_at is a date and is not a detail field
The date that the item was placed by the customer

web_events.uri is a str and is not a detail field
The url the user came from

user_facts.last_order_date is a date and is detail field
The users last order date

user_facts.first_order_date is a date and is detail field
The users first order date

order_items.order_id is a number and is not a detail field

inventory_items.user_id is a number and is not a detail field

products.user_id is a number and is not a detail field

'Aging New Users Without Orders' is a subset of Ecomm Users with id: 7
'Low Value Users (removing new users and inactive users)' is a subset of Ecomm Users with id: 10
'New Users' is a subset of Ecomm Users with id: 6
'Users from Order Items Source' is a subset of Ecomm Users with id: 1
'Users from User Facts Source' is a subset of Ecomm Users with id: 2
'Users from User Details Source' is a subset of Ecomm Users with id: 3
'Users from Web Events Source' is a subset of Ecomm Users with id: 4
'Users from Ordered Product Source' is a subset of Ecomm Users with id: 5
'Users with Returns (90 days)' is a subset of Ecomm Users with id: 9
'New Users Ordered Sequence' is a subset of Ecomm Users with id: 12
source order_items can be filtered with fields in sources order_items, inventory_items, products.
source user_facts can be filtered with fields in sources user_facts.
source user_details can be filtered with fields in sources user_details.
source web_events can be filtered with fields in sources web_events.
source inventory_items can be filtered with fields in sources order_items, inventory_items, products.
source products can be filtered with fields in sources order_items, inventory_items, products.


<</SYS>>

the human has a question about Ecomm Users: what is the subset_expression for Top 12 California users by Age but have no orders this year? [/INST] ```subset_expression
{"symbols": {"B": {"value": {"value": 1, "filters": [{"value": {"value": "year"}, "operator": "this", "field": "order_items.created_at"}], "operator": "greater than or equal to"}, "operator": "count", "field": "order_items.user_id"}, "C": {"value": {"value": ["California"]}, "operator": "equals", "field": "user_details.state"}, "D": {"value": {"desc": true, "value": "12", "function": "average", "operator": "less than or equal to"}, "operator": "top n", "field": "user_details.age"}}, "expression": "!B>C>D", "population": "Ecomm Users"}
``` </s>