SQL Query:
SELECT s.shop_name, (SELECT COUNT(*) FROM Clothes WHERE shop_id=s.shop_id) AS clothes_count, (SELECT COUNT(*) FROM Shoes WHERE shop_id=s.shop_id) AS shoes_count, (SELECT COUNT(*) FROM Accessory WHERE shop_id=s.shop_id) AS acc_count FROM Shop s;
| Shop | City | Manager | Clothing Types | Clothing Units | Shoe Styles | Shoe Units | Accessory Types | Accessory Units | Total Units |
|---|
Detailed Inventory by Shop