Creating SQL queries for analyzing a magento online store

My webshop is running on Magento 1 and I need a bunch of SQL queries to do some analysis. The queries I need are: Relevant tables: sales_flat_order (sfo), sales_flat_order_address (sfoa), sales_flat_order_item (sfoi) All orders which are subscription orders.

Therefore I have a column „fp_abo“ in my table sales_flat_order. The output columns I need are: Company, First Name, Name, E-Mail, Telephone, Shipping Method (shipping_description in sfo), order date, ordered products (product name -> sfoi), quantity of each ordered product (qty_ordered), frequency (value of fp_abo) 2. A list of all customers/orders grouped by the sfo.shipping_arrival_date.

Columns of the output are: Customer ID, sfo.shipping_description, sfo.shipping_arrival_slot, customer first name, customer name, company, address, postal code, floor, sfo.shipping_arrival_drop, telephone, order date incl. time, value of order (incl. rebate and deposit), coupon code, existing customer / new customer flag 3. All coupons that have been used based on the shipping_arrival_date Output Columns: Coupon code, revenue (product price+shipping-deposit-rebate) rebate, no of customers who have used this code 4. All coupon codes that have been used in one month Output Columns: Information for which Shipping Arrival the code has been used, Customer First Name, Customer Name, Rebate, Code 5. List the average ordered quantity of each product based on the shipping_arrival_date. Example: 2016/04/31 - Milk - 4 2016/04/31 - Carrots - 22