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 |
Return only missing recordsInclude customer_id, customer_name, customer_tier, bot_name, and assignment_statusSet assignment_status to `Missing Assignment`Order by customer_id, bot_name