Practice Interview Questions
| Question | Status |
|---|---|
Identify the top 5 percentile of claims from each state.
fraud_score table:
| Column Name | Data Type |
|---|---|
| policy_num | varchar |
| state | varchar |
| claim_cost | int |
| fraud_score | float |
Example output:
| policy_num | state | claim_cost |
|---|
| fraud_score |
|---|
| ABCD1016 | CA | 1639 | 0.964 |
| ABCD1027 | CA | 2663 | 0.988 |
Identify the top 5 percentile of claims from each state.
fraud_score table:
| Column Name | Data Type |
|---|---|
| policy_num | varchar |
| state | varchar |
| claim_cost | int |
| fraud_score | float |
Example output:
| policy_num | state | claim_cost | fraud_score |
|---|---|---|---|
| ABCD1016 | CA | 1639 | 0.964 |
| ABCD1027 | CA | 2663 | 0.988 |