CREATE TABLE Customer_Payments (customer_id NUMBER, datetime_payment DATETIME, payment_method_code VARCHAR2, amount_payment DOUBLE PRECISION)
CREATE TABLE Vehicles (vehicle_id NUMBER, vehicle_details VARCHAR2)
CREATE TABLE Customers (customer_id NUMBER, customer_address_id NUMBER, customer_status_code VARCHAR2, date_became_customer DATETIME, date_of_birth DATETIME, first_name VARCHAR2, last_name VARCHAR2, amount_outstanding DOUBLE PRECISION, email_address VARCHAR2, phone_number VARCHAR2, cell_mobile_phone_number VARCHAR2)
CREATE TABLE Lessons (lesson_id NUMBER, customer_id NUMBER, lesson_status_code VARCHAR2, staff_id NUMBER, vehicle_id NUMBER, lesson_date DATETIME, lesson_time VARCHAR2, price DOUBLE PRECISION)
CREATE TABLE Addresses (address_id NUMBER, line_1_number_building VARCHAR2, city VARCHAR2, zip_postcode VARCHAR2, state_province_county VARCHAR2, country VARCHAR2)
CREATE TABLE Staff (staff_id NUMBER, staff_address_id NUMBER, nickname VARCHAR2, first_name VARCHAR2, middle_name VARCHAR2, last_name VARCHAR2, date_of_birth DATETIME, date_joined_staff DATETIME, date_left_staff DATETIME)

List all payment methods and number of payments using each payment methods Plot them as bar chart, display names in ascending order please.
SELECT payment_method_code, COUNT(*) FROM Customer_Payments GROUP BY payment_method_code ORDER BY payment_method_code
SELECT "payment_method_code", COUNT(*) FROM "Customer_Payments" GROUP BY "payment_method_code" ORDER BY "payment_method_code"