David MathewClaims Analytics Lead
The CFO wants **loss ratio by product line**: approved claims ÷ premium. Use all policies we wrote, even lapsed ones.
This ticket is part of Sqlism Pro
See how Meera Krishnan handles it from start to finish:
- The clarifying questions and the manager's answers
- Step-by-step thinking behind the query
- The buggy first draft, why it's wrong, and the fix, all runnable
- A “your turn” editor that checks your answer
One-time payment. Unlocks every Pro ticket, tool, quiz level and interview topic.
Or try a free Banking & Insurance ticket: Active policies and premium by product