Here's the SQL query to find the total revenue generated by each customer in the past month:

```
SELECT Orders.CustomerID, SUM(Items.Quantity * Products.Price) AS Revenue
FROM Orders
JOIN Items ON Orders.OrderID = Items.OrderID
JOIN Products ON Items.ProductID = Products.ProductID
WHERE Orders.OrderDate >= DATEADD(month, -1, GETDATE())
GROUP BY Orders.CustomerID
ORDER BY Revenue DESC;
```

This query joins the Orders, Items, and Products tables together based on the OrderID and ProductID columns. It then calculates the revenue for each order by multiplying the quantity of each item by the price of the product, and sums up the revenue for all orders placed by each customer in the past month. Finally, the results are grouped by customer and sorted in descending order of revenue.
Date due tabelle, una per gli ordini dei clienti con le colonne OrderID, CustomerID e OrderDate e una per gli articoli dell'ordine con le colonne OrderID, ProductID e Quantity, scrivere una query SQL per trovare le entrate totali generate da ciascun cliente nell'ultimo mese, inclusi i ricavi di tutti gli ordini che il cliente ha effettuato, anche se sono stati effettuati in date diverse.