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 Customer_Policies (Policy_ID INT, Customer_ID INT, Policy_Type_Code CHAR, Start_Date DATE, End_Date DATE)
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 Customers (Customer_ID INT, Customer_Details VARCHAR)
CREATE TABLE Payments (Payment_ID INT, Settlement_ID INT, Payment_Method_Code VARCHAR, Date_Payment_Made DATE, Amount_Payment INT)

A bar chart for returning the number of the claim start date for the claims whose claimed amount is no more than the average, and rank from high to low by the y axis.
SELECT Date_Claim_Made, COUNT(Date_Claim_Made) FROM Claims WHERE Amount_Settled <= (SELECT AVG(Amount_Settled) FROM Claims) ORDER BY COUNT(Date_Claim_Made) DESC
SELECT "Date_Claim_Made", COUNT("Date_Claim_Made") FROM "Claims" WHERE "Amount_Settled" <= (SELECT AVG("Amount_Settled") FROM "Claims") ORDER BY COUNT("Date_Claim_Made") DESC NULLS LAST