Output
A team of data scientists created a handful of ML classifiers for flagging any internal work emails that would need immediate attention based on their collective historical experience.
The manager now wants to know the average precision of these classifiers weighted by the severity of issues they would flag. Write a query for the same.
Formula for weighted average = ∑ (Number X Weighing Factors) / ∑ Weights
Tables and Columns:
email_classifiers
| classifier_id | precision_percentage | severity |
|---|---|---|
| I87 | 0.6267 | 3 |
| I26 | 0.3423 | 2 |
| I101 | 0.7593 | 4 |
| I62 | 0.5503 | 3 |
| I80 | 0.7821 | 4 |
| I123 | 0.8657 | 5 |
| I55 | 0.9429 | 5 |
| I67 | 0.9576 | 4 |
| I95 | 0.8958 | 3 |
| I112 | 0.6273 | 2 |
| I82 | 0.7887 | 1 |
| I34 | 0.4539 | 2 |
| metric (VARCHAR) | value (VARCHAR) |
|---|---|
| AGG_PRECISION | 76.03 |