Home
/
Questions
/
Coding
/
Quarterly NIM pivot, full-year product lines only
caseSQL
Coding question · Conditional Pivot
Hard
Asked at JPMorgan Chase
Quarterly NIM pivot, full-year product lines only
Conditional aggregation pivot combined with HAVING filter on group completeness.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Duplicate-charge pairs within 60 seconds
Next →
Trace each active loan back to its origination