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

Give the maximum product price for each product type in a bar chart, and show in desc by the bar.
SELECT product_type_code, MAX(product_price) FROM Products GROUP BY product_type_code ORDER BY product_type_code DESC
SELECT "product_type_code", MAX("product_price") FROM "Products" GROUP BY "product_type_code" ORDER BY "product_type_code" DESC NULLS LAST