Translate the following question to SQL: For each distinct product name, show its average product price.

Schema: CREATE TABLE Ref_Payment_Methods (
    payment_method_code CHAR(10) NOT NULL  PRIMARY KEY,
    payment_method_description VARCHAR(80),
    UNIQUE (payment_method_code)
);

CREATE TABLE Ref_Service_Types (
    Service_Type_Code CHAR(15) NOT NULL  PRIMARY KEY,
    Parent_Service_Type_Code CHAR(15),
    Service_Type_Description VARCHAR(255),
    UNIQUE (Service_Type_Code)
);

CREATE TABLE Addresses (
    Address_ID VARCHAR(100) NOT NULL  PRIMARY KEY,
    Line_1 VARCHAR(255),
    Line_2 VARCHAR(255),
    City_Town VARCHAR(255),
    State_County VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Address_ID)
);

CREATE TABLE Products (
    Product_ID VARCHAR(100) NOT NULL  PRIMARY KEY,
    Product_Name VARCHAR(255),
    Product_Price DECIMAL(20,4),
    Product_Description VARCHAR(255),
    Other_Product_Service_Details VARCHAR(255),
    UNIQUE (Product_ID)
);

CREATE TABLE Marketing_Regions (
    Marketing_Region_Code CHAR(15) NOT NULL  PRIMARY KEY,
    Marketing_Region_Name VARCHAR(255) NOT NULL,
    Marketing_Region_Descriptrion VARCHAR(255) NOT NULL,
    Other_Details VARCHAR(255),
    UNIQUE (Marketing_Region_Code)
);

CREATE TABLE Clients (
    Client_ID INTEGER NOT NULL  PRIMARY KEY,
    Address_ID INTEGER NOT NULL,
    Customer_Email_Address VARCHAR(255),
    Customer_Name VARCHAR(255),
    Customer_Phone VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Client_ID),
    FOREIGN KEY (Address_ID) REFERENCES Addresses(Address_ID)
);

CREATE TABLE Drama_Workshop_Groups (
    Workshop_Group_ID INTEGER NOT NULL  PRIMARY KEY,
    Address_ID INTEGER NOT NULL,
    Currency_Code CHAR(15) NOT NULL,
    Marketing_Region_Code CHAR(15) NOT NULL,
    Store_Name VARCHAR(255),
    Store_Phone VARCHAR(255),
    Store_Email_Address VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Workshop_Group_ID),
    FOREIGN KEY (Address_ID) REFERENCES Addresses(Address_ID)
);

CREATE TABLE Performers (
    Performer_ID INTEGER NOT NULL  PRIMARY KEY,
    Address_ID INTEGER NOT NULL,
    Customer_Name VARCHAR(255),
    Customer_Phone VARCHAR(255),
    Customer_Email_Address VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Performer_ID),
    FOREIGN KEY (Address_ID) REFERENCES Addresses(Address_ID)
);

CREATE TABLE Customers (
    Customer_ID VARCHAR(100) NOT NULL  PRIMARY KEY,
    Address_ID INTEGER NOT NULL,
    Customer_Name VARCHAR(255),
    Customer_Phone VARCHAR(255),
    Customer_Email_Address VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Customer_ID),
    FOREIGN KEY (Address_ID) REFERENCES Addresses(Address_ID)
);

CREATE TABLE Stores (
    Store_ID VARCHAR(100) NOT NULL  PRIMARY KEY,
    Address_ID INTEGER NOT NULL,
    Marketing_Region_Code CHAR(15) NOT NULL,
    Store_Name VARCHAR(255),
    Store_Phone VARCHAR(255),
    Store_Email_Address VARCHAR(255),
    Other_Details VARCHAR(255),
    UNIQUE (Store_ID),
    FOREIGN KEY (Marketing_Region_Code) REFERENCES Marketing_Regions(Marketing_Region_Code),
    FOREIGN KEY (Address_ID) REFERENCES Addresses(Address_ID)
);

CREATE TABLE Bookings (
    Booking_ID INTEGER NOT NULL  PRIMARY KEY,
    Customer_ID INTEGER NOT NULL,
    Workshop_Group_ID VARCHAR(100) NOT NULL,
    Status_Code CHAR(15) NOT NULL,
    Store_ID INTEGER NOT NULL,
    Order_Date DATETIME NOT NULL,
    Planned_Delivery_Date DATETIME NOT NULL,
    Actual_Delivery_Date DATETIME NOT NULL,
    Other_Order_Details VARCHAR(255),
    UNIQUE (Booking_ID),
    FOREIGN KEY (Workshop_Group_ID) REFERENCES Drama_Workshop_Groups(Workshop_Group_ID),
    FOREIGN KEY (Customer_ID) REFERENCES Clients(Client_ID)
);

CREATE TABLE Performers_in_Bookings (
    Order_ID INTEGER NOT NULL  PRIMARY KEY,
    Performer_ID INTEGER NOT NULL  PRIMARY KEY,
    PRIMARY KEY (Order_ID, Performer_ID),
    UNIQUE (Order_ID, Performer_ID),
    FOREIGN KEY (Order_ID) REFERENCES Bookings(Booking_ID),
    FOREIGN KEY (Performer_ID) REFERENCES Performers(Performer_ID)
);

CREATE TABLE Customer_Orders (
    Order_ID INTEGER NOT NULL  PRIMARY KEY,
    Customer_ID INTEGER NOT NULL,
    Store_ID INTEGER NOT NULL,
    Order_Date DATETIME NOT NULL,
    Planned_Delivery_Date DATETIME NOT NULL,
    Actual_Delivery_Date DATETIME NOT NULL,
    Other_Order_Details VARCHAR(255),
    UNIQUE (Order_ID),
    FOREIGN KEY (Store_ID) REFERENCES Stores(Store_ID),
    FOREIGN KEY (Customer_ID) REFERENCES Customers(Customer_ID)
);

CREATE TABLE Order_Items (
    Order_Item_ID INTEGER NOT NULL  PRIMARY KEY,
    Order_ID INTEGER NOT NULL,
    Product_ID INTEGER NOT NULL,
    Order_Quantity VARCHAR(288),
    Other_Item_Details VARCHAR(255),
    FOREIGN KEY (Product_ID) REFERENCES Products(Product_ID),
    FOREIGN KEY (Order_ID) REFERENCES Customer_Orders(Order_ID)
);

CREATE TABLE Invoices (
    Invoice_ID INTEGER NOT NULL  PRIMARY KEY,
    Order_ID INTEGER NOT NULL,
    payment_method_code CHAR(15),
    Product_ID INTEGER NOT NULL,
    Order_Quantity VARCHAR(288),
    Other_Item_Details VARCHAR(255),
    Order_Item_ID INTEGER NOT NULL,
    FOREIGN KEY (payment_method_code) REFERENCES Ref_Payment_Methods(payment_method_code),
    FOREIGN KEY (Order_ID) REFERENCES Bookings(Booking_ID),
    FOREIGN KEY (Order_ID) REFERENCES Customer_Orders(Order_ID)
);

CREATE TABLE Services (
    Service_ID INTEGER NOT NULL  PRIMARY KEY,
    Service_Type_Code CHAR(15),
    Workshop_Group_ID INTEGER NOT NULL,
    Product_Description VARCHAR(255),
    Product_Name VARCHAR(255),
    Product_Price DECIMAL(20,4),
    Other_Product_Service_Details VARCHAR(255),
    UNIQUE (Service_ID),
    FOREIGN KEY (Service_Type_Code) REFERENCES Ref_Service_Types(Service_Type_Code),
    FOREIGN KEY (Workshop_Group_ID) REFERENCES Drama_Workshop_Groups(Workshop_Group_ID)
);

CREATE TABLE Bookings_Services (
    Order_ID INTEGER NOT NULL  PRIMARY KEY,
    Product_ID INTEGER NOT NULL  PRIMARY KEY,
    PRIMARY KEY (Order_ID, Product_ID),
    UNIQUE (Order_ID, Product_ID),
    FOREIGN KEY (Product_ID) REFERENCES Services(Service_ID),
    FOREIGN KEY (Order_ID) REFERENCES Bookings(Booking_ID)
);

CREATE TABLE Invoice_Items (
    Invoice_Item_ID INTEGER NOT NULL  PRIMARY KEY,
    Invoice_ID INTEGER NOT NULL,
    Order_ID INTEGER NOT NULL,
    Order_Item_ID INTEGER NOT NULL,
    Product_ID INTEGER NOT NULL,
    Order_Quantity INTEGER,
    Other_Item_Details VARCHAR(255),
    FOREIGN KEY (Order_ID) REFERENCES Bookings_Services(Order_ID),
    FOREIGN KEY (Product_ID) REFERENCES Bookings_Services(Product_ID),
    FOREIGN KEY (Invoice_ID) REFERENCES Invoices(Invoice_ID),
    FOREIGN KEY (Order_Item_ID) REFERENCES Order_Items(Order_Item_ID)
);
user
SELECT Product_Name ,  avg(Product_Price) FROM PRODUCTS GROUP BY Product_Name
assistant