Database schema:
CREATE TABLE Products (
  product_id NUMBER PRIMARY KEY,
  product_type_code TEXT,
  product_name TEXT,
  product_price NUMBER
);
CREATE TABLE Addresses (
  address_id NUMBER PRIMARY KEY,
  address_details TEXT
);
CREATE TABLE Customers (
  customer_id NUMBER PRIMARY KEY,
  address_id NUMBER,
  payment_method_code TEXT,
  customer_number TEXT,
  customer_name TEXT,
  customer_address TEXT,
  customer_phone TEXT,
  customer_email TEXT
);
CREATE TABLE Customer_Orders (
  order_id NUMBER PRIMARY KEY,
  customer_id NUMBER,
  order_date TIME,
  order_status_code TEXT,
  FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);
CREATE TABLE Order_Items (
  order_item_id NUMBER,
  order_id NUMBER,
  product_id NUMBER,
  order_quantity TEXT,
  FOREIGN KEY (product_id) REFERENCES Products(product_id),
  FOREIGN KEY (order_id) REFERENCES Customer_Orders(order_id)
);

Question: Show the order ids, order dates, and order status codes for all orders by customer Jeromy.
SQL: SELECT order_id ,  order_date ,  order_status_code FROM Customer_orders AS T1 JOIN Customers AS T2 ON T1.customer_id  =  T2.customer_id WHERE T2.customer_name  =  "Jeromy"

Question: Show all product names without an order.
SQL: SELECT product_name FROM Products EXCEPT SELECT T1.product_name FROM Products AS t1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id

Question: Give the different payment method codes that customers use.
SQL: SELECT DISTINCT payment_method_code FROM Customers

Question: How many products named Monitor have been ordered?
SQL: SELECT sum(order_quantity) FROM Order_items AS T1 JOIN Products AS T2 ON T1.product_id  =  T2.product_id WHERE T2.product_name  =  "Monitor"

Question: What are the names of products that have a price above the average for all products.
SQL: SELECT product_name FROM Products WHERE product_price  >  (SELECT avg(product_price) FROM Products)

Question: What are the minimum, average, and maximum prices across all products?
SQL: SELECT min(product_price) ,  avg(product_price) ,  max(product_price) FROM Products

Question: Give the id, name, phone, and email corresponding to the customer who made the most orders.
SQL: SELECT T1.customer_id ,  T2.customer_name ,  T2.customer_phone ,  T2.customer_email FROM Customer_orders AS T1 JOIN Customers AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1

Question: What is the average price for products with type Clothes?
SQL: SELECT avg(product_price) FROM Products WHERE product_type_code  =  "Clothes"

Question: What were the ids, dates, and status codes for orders made by Jeromy?
SQL: SELECT order_id ,  order_date ,  order_status_code FROM Customer_orders AS T1 JOIN Customers AS T2 ON T1.customer_id  =  T2.customer_id WHERE T2.customer_name  =  "Jeromy"

Question: Give the product type codes of product types that have two or more products.
SQL: SELECT product_type_code FROM Products GROUP BY product_type_code HAVING count(*)  >=  2

Question: What are the ids of customers who have not made an order?
SQL: SELECT customer_id FROM Customers EXCEPT SELECT customer_id FROM Customer_orders

Question: Give the code of the payment method that is most commonly used.
SQL: SELECT payment_method_code FROM Customers GROUP BY payment_method_code ORDER BY count(*) DESC LIMIT 1

Question: Show all hardware product names with price higher than the average price of hardware type products.
SQL: SELECT product_name FROM Products WHERE product_type_code  =  "Hardware" AND product_price  >  (SELECT avg(product_price) FROM Products WHERE product_type_code  =  "Hardware")

Question: How many addresses do we have?
SQL: SELECT count(*) FROM Addresses

Question: List all product type codes and the number of products in each type.
SQL: SELECT product_type_code ,  count(*) FROM Products GROUP BY product_type_code

Question: Count the number of customer orders.
SQL: SELECT count(*) FROM Customer_orders

Question: Show all customer ids and customer names.
SQL: SELECT customer_id ,  customer_name FROM Customers

Question: Give the address, phone, and email for customers with the name Jeromy.
SQL: SELECT customer_address ,  customer_phone ,  customer_email FROM Customers WHERE customer_name  =  "Jeromy"

Question: Show all customer ids without an order.
SQL: SELECT customer_id FROM Customers EXCEPT SELECT customer_id FROM Customer_orders

Question: List all address ids and address details.
SQL: SELECT address_id ,  address_details FROM Addresses

Question: What is the product type code with most number of products?
SQL: SELECT product_type_code FROM Products GROUP BY product_type_code ORDER BY count(*) DESC LIMIT 1