Here's a SQL query that will give you the total revenue generated by each customer in the year 2022:

```
SELECT customer_id, SUM(amount) AS total_revenue
FROM orders
WHERE YEAR(order_date) = 2022
GROUP BY customer_id;
``` 

Explanation: the query groups the orders by customer and calculates the total amount of revenue generated by each customer in the year 2022. The WHERE clause filters out records with a year other than 2022 from the calculation.
Supponiamo di avere una tabella denominata &quot;orders&quot; con le colonne &quot;order_id&quot;, &quot;customer_id&quot;, &quot;order_date&quot; e &quot;amount&quot;. Scrivi una query SQL per trovare l'importo totale delle entrate generate da ciascun cliente nell'anno 2022.