Tell me about a time you used SQL, R, Python, and AWS together in your data work.
For the SQL portion, summarize completed tool runs for each work item, including items with no completed runs.
work_item_id, work_item_name, sql_run_count, r_run_count, python_run_count, aws_run_count, and tool_coverageComplete, Partial, or None, and order by work_item_id| Column | Type | Description |
|---|---|---|
| work_item_idPK | INT | Unique identifier for a data work item |
| work_item_name | VARCHAR(100) | Name of the data work item |
| owner_name | VARCHAR(100) | Person responsible for the work item |
| started_on | DATE | Date the work item started |
| work_status | VARCHAR(30) | Current status of the work item |
| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Unique identifier for a tool run |
| work_item_id | INT | Work item associated with the run |
| tool_name | VARCHAR(30) | Tool used for the run |
| run_status | VARCHAR(30) | Outcome of the tool run |
| run_date | DATE | Date the tool run occurred |
| rows_processed | INT | Number of records processed by the run |