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

Please use a bar chart to show the average amount of payment by each payment method code, rank x-axis from low to high order.
SELECT Payment_Method_Code, AVG(Amount_Payment) FROM Payments GROUP BY Payment_Method_Code ORDER BY Payment_Method_Code
SELECT "Payment_Method_Code", AVG("Amount_Payment") FROM "Payments" GROUP BY "Payment_Method_Code" ORDER BY "Payment_Method_Code"