Your question is Filter Open Veeva Vault Records. Start with the requirements and the one table 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.
You are given a table of Veeva Vault document records. Write a SQL query to return the document_id, document_name, owner_name, and status for records where the document status is 'Open' and the owner is 'Priya Shah'. Sort the result by document_id in ascending order.
| Column | Type | Description |
|---|---|---|
| document_idPK | INT | Unique document identifier |
| document_name | VARCHAR(100) | Name of the Veeva Vault document |
| owner_name | VARCHAR(100) | Name of the document owner |
| status | VARCHAR(20) | Current document status |
| created_date | DATE | Date the document was created |