CREATE TABLE Invoices (invoice_number INT, order_id INT, invoice_date DATETIME)
CREATE TABLE Financial_Transactions (transaction_id INT, account_id INT, invoice_number INT, transaction_type VARCHAR, transaction_date DATETIME, transaction_amount DECIMAL, transaction_comment VARCHAR, other_transaction_details VARCHAR)
CREATE TABLE Invoice_Line_Items (order_item_id INT, invoice_number INT, product_id INT, product_title VARCHAR, product_quantity VARCHAR, product_price DECIMAL, derived_product_cost DECIMAL, derived_vat_payable DECIMAL, derived_total_cost DECIMAL)
CREATE TABLE Order_Items (order_item_id INT, order_id INT, product_id INT, product_quantity VARCHAR, other_order_item_details VARCHAR)
CREATE TABLE Products (product_id INT, parent_product_id INT, production_type_code VARCHAR, unit_price DECIMAL, product_name VARCHAR, product_color VARCHAR, product_size VARCHAR)
CREATE TABLE Product_Categories (production_type_code VARCHAR, product_type_description VARCHAR, vat_rating DECIMAL)
CREATE TABLE Customers (customer_id INT, customer_first_name VARCHAR, customer_middle_initial VARCHAR, customer_last_name VARCHAR, gender VARCHAR, email_address VARCHAR, login_name VARCHAR, login_password VARCHAR, phone_number VARCHAR, town_city VARCHAR, state_county_province VARCHAR, country VARCHAR)
CREATE TABLE Accounts (account_id INT, customer_id INT, date_account_opened DATETIME, account_name VARCHAR, other_account_details VARCHAR)
CREATE TABLE Orders (order_id INT, customer_id INT, date_order_placed DATETIME, order_details VARCHAR)

Show order ids and the number of products in each order by a scatter chart.
SELECT order_id, COUNT(DISTINCT product_id) FROM Order_Items
SELECT "order_id", COUNT(DISTINCT "product_id") FROM "Order_Items"