Your question is Find Missing Bot Assignments. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |