Eligible Trade-In Payouts

Problem

Table: `TradeIn`

```text
+----------+-----------+-----------+--------+--------+
| Column | Type | | | |
+----------+-----------+-----------+--------+--------+
| trade_id | int | | | |
| base_val | float | | | |
| payout | float | | | |
| east | float | | | |
| north | float | | | |
+----------+-----------+-----------+--------+--------+
trade_id is the primary key. `base_val` is the appraised base value, `payout` is the offered payout, and (`east`, `north`) is the grid location of the drop-off depot (never NULL).
```

Report the sum of `payout` over all trade-ins that satisfy **both**:

- their `base_val` equals the `base_val` of at least one other trade-in, **and**
- their depot location (`east`, `north`) is unique — no other trade-in shares the same (east, north) pair.

Round the total to **two decimal places** and label the column `payout`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns payout.

Starter code (SQL)

SELECT *
FROM TradeIn;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium