Return the average price of products that have each category code, and show X in desc order.
CREATE TABLE Complaints (
    complaint_id INTEGER,
    product_id INTEGER,
    customer_id INTEGER,
    complaint_outcome_code VARCHAR(20),
    complaint_status_code VARCHAR(20),
    complaint_type_code VARCHAR(20),
    date_complaint_raised DATETIME,
    date_complaint_closed DATETIME,
    staff_id INTEGER
)

CREATE TABLE Staff (
    staff_id INTEGER,
    gender VARCHAR(1),
    first_name VARCHAR(80),
    last_name VARCHAR(80),
    email_address VARCHAR(255),
    phone_number VARCHAR(80)
)

CREATE TABLE Customers (
    customer_id INTEGER,
    customer_type_code VARCHAR(20),
    address_line_1 VARCHAR(80),
    address_line_2 VARCHAR(80),
    town_city VARCHAR(80),
    state VARCHAR(80),
    email_address VARCHAR(255),
    phone_number VARCHAR(80)
)

CREATE TABLE Products (
    product_id INTEGER,
    parent_product_id INTEGER,
    product_category_code VARCHAR(20),
    date_product_first_available DATETIME,
    date_product_discontinued DATETIME,
    product_name VARCHAR(80),
    product_description VARCHAR(255),
    product_price DECIMAL(19,4)
)
SELECT product_category_code, AVG(product_price) FROM Products GROUP BY product_category_code ORDER BY product_category_code DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Return the average price of products that have each category code, and show X in desc order. ### Input: CREATE TABLE Complaints (
    complaint_id INTEGER,
    product_id INTEGER,
    customer_id INTEGER,
    complaint_outcome_code VARCHAR(20),
    complaint_status_code VARCHAR(20),
    complaint_type_code VARCHAR(20),
    date_complaint_raised DATETIME,
    date_complaint_closed DATETIME,
    staff_id INTEGER
)

CREATE TABLE Staff (
    staff_id INTEGER,
    gender VARCHAR(1),
    first_name VARCHAR(80),
    last_name VARCHAR(80),
    email_address VARCHAR(255),
    phone_number VARCHAR(80)
)

CREATE TABLE Customers (
    customer_id INTEGER,
    customer_type_code VARCHAR(20),
    address_line_1 VARCHAR(80),
    address_line_2 VARCHAR(80),
    town_city VARCHAR(80),
    state VARCHAR(80),
    email_address VARCHAR(255),
    phone_number VARCHAR(80)
)

CREATE TABLE Products (
    product_id INTEGER,
    parent_product_id INTEGER,
    product_category_code VARCHAR(20),
    date_product_first_available DATETIME,
    date_product_discontinued DATETIME,
    product_name VARCHAR(80),
    product_description VARCHAR(255),
    product_price DECIMAL(19,4)
) ### Response: SELECT product_category_code, AVG(product_price) FROM Products GROUP BY product_category_code ORDER BY product_category_code DESC