ブログエントリ by 97213529 郭益銘
世界中の誰でも閲覧可
Select Store.Sales_Region, dog from
(Select Store.Sales_Region, SUM(Total) as dog from
(SELECT Sale.Store_No, SUM(Sale.Units_Sold* Item.Unit_Price) as Total
from Sale, Item
where Sale.Item_No = Item.Item_No group by Sale.Store_No) , Store
where Sale.Store_No = Store.Store_No
group by Store.Sales_Region)
where dog =
(Select Max(dog) from
(Select Store.Sales_Region, SUM(Total) as dog from
(SELECT Sale.Store_No, SUM(Sale.Units_Sold* Item.Unit_Price) as Total
from Sale, Item
where Sale.Item_No = Item.Item_No group by Sale.Store_No) , Store
where Sale.Store_No = Store.Store_No
group by Store.Sales_Region))