# The Multivac — Evaluation Report

**Evaluation ID:** EVAL-20260317-021652
**Date:** Mar 17, 2026
**Category:** code
**Question ID:** EVAL-20260317-021652

---

## Question

This SQL query takes 45 seconds on a table with 10M rows. Rewrite it to run in under 1 second. Explain your optimization strategy.

```sql
SELECT u.name, u.email,
       (SELECT COUNT(*) FROM orders o WHERE o.user_id = u.id) as order_count,
       (SELECT SUM(amount) FROM orders o WHERE o.user_id = u.id) as total_spent,
       (SELECT MAX(created_at) FROM orders o WHERE o.user_id = u.id) as last_order
FROM users u
WHERE u.created_at > '2024-01-01'
AND (SELECT COUNT(*) FROM orders o WHERE o.user_id = u.id) > 5
ORDER BY total_spent DESC
LIMIT 100;
```

Assume standard B-tree indexes on primary keys only. What indexes would you add?

---

## Winner

**Qwen 3.5 397B-A17B** (openrouter)
- Winner Score: 9.55
- Matrix Average: 9.34
- Total Judgments: 53

---

## Rankings

| Rank | Model | Provider | Avg Score | Judgments |
|------|-------|----------|-----------|----------|
| 1 | Qwen 3.5 397B-A17B | openrouter | 9.55 | 6 |
| 2 | Qwen 3.5 27B | openrouter | 9.51 | 7 |
| 3 | Qwen 3.5 122B-A10B | openrouter | 9.43 | 7 |
| 4 | Qwen 3 Coder Next | openrouter | 9.38 | 7 |
| 5 | Qwen 3.5 9B | openrouter | 9.34 | 6 |
| 6 | Qwen 3 32B | openrouter | 9.25 | 7 |
| 7 | Qwen 3 8B | openrouter | 9.22 | 6 |
| 8 | Qwen 3.5 35B-A3B | openrouter | 9.06 | 7 |

---

## 10×10 Judgment Matrix

Rows = Judge, Columns = Respondent. Self-judgments excluded (—).

| Judge ↓ / Resp → | Qwen 3.5 9B | Qwen 3 8B | Qwen 3 32B | Qwen 3 | Qwen 3.5 | Qwen 3.5 27B | Qwen 3.5 | Qwen 3.5 |
|---|---|---|---|---|---|---|---|---|
| Qwen 3.5 9B | — | · | 8.4 | 9.0 | 8.3 | 8.8 | 8.8 | 9.0 |
| Qwen 3 8B | 9.4 | — | 9.6 | 10.0 | 10.0 | 10.0 | 9.6 | 10.0 |
| Qwen 3 32B | 9.6 | 10.0 | — | 10.0 | 9.3 | 9.8 | 10.0 | 10.0 |
| Qwen 3 | 10.0 | 10.0 | 10.0 | — | 10.0 | 10.0 | 10.0 | 10.0 |
| Qwen 3.5 | · | 8.6 | 9.6 | 8.8 | — | 8.7 | 9.2 | · |
| Qwen 3.5 27B | 8.6 | 8.6 | 8.6 | 8.8 | 7.8 | — | 8.6 | 8.9 |
| Qwen 3.5 | 9.0 | 8.2 | 8.6 | 9.6 | 8.4 | 9.8 | — | 9.3 |
| Qwen 3.5 | 9.6 | 10.0 | 10.0 | 9.6 | 9.6 | 9.6 | 9.8 | — |

---

## Methodology

- **10×10 Blind Peer Matrix:** All models answer the same question, then all models judge all responses.
- **5 Criteria:** Correctness, completeness, clarity, depth, usefulness (each scored 1–10).
- **Self-judgments excluded:** Models do not judge their own responses.
- **Weighted Score:** Composite of all 5 criteria.

---

## Citation

The Multivac (2026). Blind Peer Evaluation: EVAL-20260317-021652. app.themultivac.com

## License

Open data. Free to use, share, and build upon. Please cite The Multivac when using this data.

Download raw JSON: https://app.themultivac.com/api/evaluations/EVAL-20260317-021652/results
Full dataset: https://app.themultivac.com/dashboard/export