AI Platform Economics

# AI Platform Economics

_Empty report_

Calculate success rates and usage costs, prevent join fan-out, and reconcile split payments with refunds.

- Sample database: ModelWorks (ai_accounts, ai_requests, model_rates, invoices, payments, refunds)
- Milestones completed (SQL + concept check): 0 of 4
- Findings written: 0 of 4
- Verified checks (Check answer passed): 0
- Exported: 2026-10-14T03:38:09.516Z

Findings are the learner’s own interpretation. Passing a SQL check does not verify the written finding.

## Milestone 1: Ratios, ROUND & NULLIF

Status: Not started

_No finding written yet._

### 1.1 Return account_id and success_pct (0–100, rounded to 2 decimals) for accounts with requests.

_not attempted_

### 1.2 Return id and success_pct for every account, including accounts with no requests (NULL rate). Round to 2 decimals.

_not attempted_

## Milestone 2: Multi-grain joins without fan-out

Status: Not started

_No finding written yet._

### 2.1 Return id, request_count and billed_amount for every account across all dates. Aggregate requests and invoices separately to avoid multiplication; use zeros for missing totals.

_not attempted_

### 2.2 Return id, output_tokens and billed_amount for every account across all dates. Sum only successful output tokens and aggregate invoices separately. Use zeros for missing totals.

_not attempted_

## Milestone 3: Revenue & payment reconciliation

Status: Not started

_No finding written yet._

### 3.1 Return id, billed_amount, net_collected and gap for every invoice across all periods. Net collected = payments - refunds; gap = billed - net collected. Treat missing totals as zero.

_not attempted_

### 3.2 Using the same definition, return invoice_id and gap only for invoices with nonzero gap.

_not attempted_

## Milestone 4: AI usage cost & contribution margin

Status: Not started

_No finding written yet._

### 4.1 Return model and usage_cost in fictional USD, rounded to 6 decimals, for successful requests across all dates.

_not attempted_

### 4.2 Return id, billed_amount, usage_cost and contribution_margin for every account for Jan 2025. Use January invoices and successful requests only; missing totals are zero. Round cost and margin to 6 decimals. Margin = billed - usage cost.

_not attempted_