A customer has provided Moveworks with access to its user database. The product owner needs a CSV-ready report containing only active users whose email address ends with .test.
Write a PostgreSQL query that joins the customer user records with their directory email records.
active..test, using case-insensitive matching.| Column | Type | Description |
|---|---|---|
| user_idPK | INTEGER | Unique customer user identifier |
| status | VARCHAR(20) | Current status of the user account |
| Column | Type | Description |
|---|---|---|
| directory_user_idPK | INTEGER | User identifier associated with the customer directory |
| VARCHAR(255) | User email address | |
| display_name | VARCHAR(120) | User-facing directory name |