---
name: sql-analytics-conventions-mt
source: https://app.decimal.ai/s/sql-analytics-conventions-mt@1/SKILL.md
source_sha256: 0f3c7e094537
---

# Schema for this database (front-loaded so you don't have to explore it)
- users(id, signup_at, region): region is 'EU' | 'US' | 'APAC'.
- orders(id, user_id, net_amount_cents, status, created_at): net_amount_cents is CENTS (divide by 100 for dollars); status is 'completed' | 'pending' | 'cancelled' — only 'completed' is revenue.
Join orders.user_id = users.id. Answer with a single SUM query.