CREATE TABLE Settlements (Settlement_ID NUMBER, Claim_ID NUMBER, Date_Claim_Made DATE, Date_Claim_Settled DATE, Amount_Claimed NUMBER, Amount_Settled NUMBER, Customer_Policy_ID NUMBER)
CREATE TABLE Customers (Customer_ID NUMBER, Customer_Details VARCHAR2)
CREATE TABLE Claims (Claim_ID NUMBER, Policy_ID NUMBER, Date_Claim_Made DATE, Date_Claim_Settled DATE, Amount_Claimed NUMBER, Amount_Settled NUMBER)
CREATE TABLE Payments (Payment_ID NUMBER, Settlement_ID NUMBER, Payment_Method_Code VARCHAR2, Date_Payment_Made DATE, Amount_Payment NUMBER)
CREATE TABLE Customer_Policies (Policy_ID NUMBER, Customer_ID NUMBER, Policy_Type_Code CHAR, Start_Date DATE, End_Date DATE)

Find the number of settlements each claim corresponds to. Show the number together with the claim id. Visualize by scatter chart.
SELECT T1.Claim_ID, COUNT(*) FROM Claims AS T1 JOIN Settlements AS T2 ON T1.Claim_ID = T2.Claim_ID GROUP BY T1.Claim_ID
SELECT "T1"."Claim_ID", COUNT(*) FROM "Claims" "T1" JOIN "Settlements" "T2" ON "T1"."Claim_ID" = "T2"."Claim_ID" GROUP BY "T1"."Claim_ID"