Table Name: warehouse_inventory
warehouse product units
ABC1 XYZ 3
ABC1 DEF 4
ABC1 LMN 12
ABC1 GHI 4
ABC2 XYZ 10
ABC2 PQR 1
ABC2 LMN 4
ABC2 GHI 7
ABC3 XYZ 5
ABC3 PQR 3
ABC3 GHI 10
ABC3 LMN 2

Table Name: product_dimensions_inches
product W L H
XYZ 12 10 8
PQR 4 3 3
... ... ... ...
LMN - 5 2
GHI 10 3 -
DEF 3 2 4
JKL 2 - 2

Given two tables above, write individual SQL scripts that will answer following:

1. How many unique products does the company have in inventory? correct

2. How many units per warehouse?

3. How much cubic feet of volume does the inventory occupy in each warehouse?

4. What % of cubic feet of volume does each warehouse contribute to the entire network?

5. How many units of inventory in the company are either missing or have incomplete dimensions?

6. What are the 3 most common products per warehouse?