Join origination to product, filter to mortgage subcategory, count last-30-days fundings
Board prep number. How many mortgage loans funded in the last 30 days — that's `funded_date` from 2026-03-30 through 2026-04-29 inclusive — for products in the Mortgage subcategory only? Single scalar, alias it `mortgages_30d`. Just the funding count, no balance sum.
| Column | Type | Key |
|---|---|---|
| origination_id | INT | PK |
| app_id | INT | FK → lending_applications |
| account_id | INT | FK → retail_accounts |
| funded_date | TEXT | |
| funded_amount | REAL | |
| term_months | INT | |
| interest_rate | REAL | |
| rate_type | TEXT | |
| arm_reset_date | TEXT | |
| fico_at_orig | INT | |
| dti_at_orig | REAL | |
| ltv_at_orig | REAL | |
| property_value | REAL | |
| lo_name | TEXT | |
| channel | TEXT | |
| current_status | TEXT | |
| closed_date | TEXT |
| Column | Type | Key |
|---|---|---|
| app_id | INT | PK |
| customer_id | INT | FK → retail_customers |
| product_id | INT | FK → retail_products |
| application_date | TEXT | |
| requested_amount | REAL | |
| requested_term | INT | |
| loan_purpose | TEXT | |
| action_taken | INT | |
| denial_reason_1 | INT | |
| aus_recommendation | TEXT | |
| rate_spread | REAL | |
| lien_status | INT | |
| occupancy | INT | |
| ethnicity | INT | |
| race | INT | |
| sex | INT | |
| age_bucket | TEXT | |
| property_tract | TEXT | FK → lending_geography |
| Column | Type | Key |
|---|---|---|
| product_id | INT | PK |
| product_code | TEXT | |
| product_name | TEXT | |
| category | TEXT | |
| subcategory | TEXT | |
| default_apr | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
Two filters compose: a date window on funded_date, and a product-subcategory restriction. Subcategory lives on `retail_products`, not on the originations row, so a JOIN is required to reach it.
Re-run M2's product taxonomy if you need to remind yourself which subcategory label the briefing wants. Filtering on the subcategory string is more durable than hardcoding individual product codes — if a new mortgage product launches, the report still works.
Single scalar output, aliased so the board deck binds cleanly. Inclusive on both ends of the date window; the board number includes today's fundings.