BeginnerFinanceSQL+20 XP

High-value claims in the North region

Scenario

You are a data analyst. You have joined the claims analytics team at a short-term insurer. The regional manager for North suspects a spike in large motor claims and wants the list before the 10:00 review.

Question

Return claim_id, region, incident_type, claim_amount and settlement_days for North claims above R5 000, largest first.

Your task

Select only the five requested columns
Filter to region 'North' and claim_amount greater than 5000
Order by claim_amount descending

SQLSELECTWHERESorting

Read the simple theory: SQL

Beginner · WHERE And Sorting & Record Counting — question 6 of 30

Finish all 30 to earn a certificate

1. Choose your dataset

Pick an industry and a size. Your code and results change to match.

IndustrySize

sql editorinsurance_claims

Snippets

💡 Explain my whole code, line by line (hover any word in the editor for a tip)

🌈 In short — no coding words

📂 Opens the "insurance_claims" table→✅ Shows you the answer

Altogether: this query reads your industry table, picks what you need, and shows the answer as rows.

Start typing to see suggestions. Press Enter to use one. Red marks show the line to fix. Drag a bottom corner horizontally and vertically to resize.

Type your code here ↓Tap or click inside the box to start

✍️ Tap here to type

Dataset & schema

insurance_claims

IndustryDataset size

The tiny starter data. Bigger data scrolls.

Fields

claim_id	region	incident_type	claim_amount	settlement_days
CLM-1001	North	Collision	8400	21
CLM-1002	South	Hail	3200	14
CLM-1003	North	Theft	12750	35
CLM-1004	North	Collision	4300	12
CLM-1005	East	Collision	9100	28
CLM-1006	North	Hail	6600	19

8 columns in the live table; 6 sample rows shown.

attempts: 0

▶ Output terminal

$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

5 left

Selects claim_amount
Reads insurance_claims
Filters region North
Filters amount > 5000
Sorts descending