Order Value per Region
Please assist. I would like to answer this question: "What is the average order value in the African Region per month?"
SELECT Avg(Orders) AS Order Value
FROM Orders, Customer, Nation, Region
Join Customer AS C
ON Customer.Custkey = Orders.Custkey
Join Customer AS C ON Customer.Nationkey=Nation.Nationkey
where Region = Africa