Write a SQL query to track operational throughput by day at Tempus labs, join it to quality outcomes, and identify trends by team or site.
Use the operational_runs and quality_checks tables. Include operational activity from January 1 through January 4, 2024, preserving operational groups that have no quality records.
operation_date, team, site, throughput_units, inspected_units, defect_units, quality_percent, quality_status, and quality_runs.operation_date, team, and site ascending.| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Unique operational run identifier |
| completed_at | TIMESTAMP | Timestamp when the run completed |
| team | VARCHAR(50) | Operations team responsible for the run |
| site | VARCHAR(80) | Tempus Labs processing site |
| units_processed | INT | Units processed by the run |
| accepted_units | INT | Units accepted during the run |
| Column | Type | Description |
|---|---|---|
| check_idPK | INT | Unique quality check identifier |
| run_id | INT | Operational run evaluated by the check |
| inspected_units | INT | Units included in the quality inspection |
| defect_count | INT | Defective units found during inspection |