Write a PostgreSQL query to find customers in Automation Anywhere data who require a bot assignment but do not currently have a matching active assignment. A match must use both customer_id and bot_name, and inactive assignments should still count as missing.
| Column | Type | Description |
|---|---|---|
| requirement_id | ||
| customer_id | ||
| customer_name | ||
| customer_tier | ||
| bot_name | ||
| requires_assignment |
| Column | Type | Description |
|---|---|---|
| assignment_id | ||
| customer_id | ||
| bot_name | ||
| assigned_on | ||
| is_active |