CREATE TABLE Department_Store_Chain (dept_store_chain_id NUMBER, dept_store_chain_name VARCHAR2)
CREATE TABLE Suppliers (supplier_id NUMBER, supplier_name VARCHAR2, supplier_phone VARCHAR2)
CREATE TABLE Order_Items (order_item_id NUMBER, order_id NUMBER, product_id NUMBER)
CREATE TABLE Customer_Orders (order_id NUMBER, customer_id NUMBER, order_status_code VARCHAR2, order_date DATETIME)
CREATE TABLE Department_Stores (dept_store_id NUMBER, dept_store_chain_id NUMBER, store_name VARCHAR2, store_address VARCHAR2, store_phone VARCHAR2, store_email VARCHAR2)
CREATE TABLE Customers (customer_id NUMBER, payment_method_code VARCHAR2, customer_code VARCHAR2, customer_name VARCHAR2, customer_address VARCHAR2, customer_phone VARCHAR2, customer_email VARCHAR2)
CREATE TABLE Customer_Addresses (customer_id NUMBER, address_id NUMBER, date_from DATETIME, date_to DATETIME)
CREATE TABLE Departments (department_id NUMBER, dept_store_id NUMBER, department_name VARCHAR2)
CREATE TABLE Addresses (address_id NUMBER, address_details VARCHAR2)
CREATE TABLE Staff (staff_id NUMBER, staff_gender VARCHAR2, staff_name VARCHAR2)
CREATE TABLE Supplier_Addresses (supplier_id NUMBER, address_id NUMBER, date_from DATETIME, date_to DATETIME)
CREATE TABLE Products (product_id NUMBER, product_type_code VARCHAR2, product_name VARCHAR2, product_price NUMBER)
CREATE TABLE Staff_Department_Assignments (staff_id NUMBER, department_id NUMBER, date_assigned_from DATETIME, job_title_code VARCHAR2, date_assigned_to DATETIME)
CREATE TABLE Product_Suppliers (product_id NUMBER, supplier_id NUMBER, date_supplied_from DATETIME, date_supplied_to DATETIME, total_amount_purchased VARCHAR2, total_value_purchased NUMBER)

What is the average price for each type of product.
SELECT product_type_code, AVG(product_price) FROM Products GROUP BY product_type_code
SELECT "product_type_code", AVG("product_price") FROM "Products" GROUP BY "product_type_code"