Artificial Intelligence, Machine Learning, Data Science, Python, Programming.
Category table, the query might look like 'SELECT Category.Name, AVG(SalesOrder.TotalSales) FROM SalesOrder JOIN Product ON SalesOrder.ProductID = Product.ProductID JOIN Category ON Product.CategoryID = Category.CategoryID WHERE MONTH(SalesOrder.OrderDate) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)