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

Find the the customer details and id for the customers who had more than one policy, and rank by the Y in asc.
SELECT T1.Customer_Details, T1.Customer_ID FROM Customers AS T1 JOIN Customer_Policies AS T2 ON T1.Customer_ID = T2.Customer_ID ORDER BY T1.Customer_ID
SELECT "T1"."Customer_Details", "T1"."Customer_ID" FROM "Customers" AS "T1" JOIN "Customer_Policies" AS "T2" ON "T1"."Customer_ID" = "T2"."Customer_ID" ORDER BY "T1"."Customer_ID" NULLS FIRST