Final answer:
The questions relate to extracting specific shipping information from a company's database and would require SQL queries. Precise answers cannot be provided without access to the actual data.
Step-by-step explanation:
Order Listing for Warehouse W2 and Customer Shipments
The questions appear to be related to database queries for a company's shipping details. To address them, we would need access to the company's database containing orders, customers, warehouses, and shipment details. The requests involve filtering and calculating information from this dataset. Unfortunately, without the actual data, creating precise query results or tables is impossible. However, in a real-world scenario, these questions would typically be answered using SQL queries on the company's database system.
Suggested Queries based on the given questions:
To list the Order# and Ship_date for orders shipped from Warehouse# W2, an SQL query filtering on the specified warehouse would be used.
Information related to all orders supplied to the customer named Jose Lopez could be retrieved using a join operation connecting customers with orders and warehouses, filtering by the customer's name.
The listing of customer name (Cname), the total number of orders (No_of_orders), and the average order amount (Avg_order_amt) would involve grouping by customer name and calculating aggregates.
Identifying orders that were not shipped within 30 days would require a date comparison operation between the order date and ship date.
For the last question, one would need to first identify all New York warehouses and then list orders shipped from all these locations.