Sure! Here's the SQL query to find the top 5 products with the highest total sales in the month of December 2021:

```
SELECT product_id, SUM(sale_amount) AS total_sales
FROM sales
WHERE MONTH(sale_date) = 12 AND YEAR(sale_date) = 2021
GROUP BY product_id
ORDER BY total_sales DESC
LIMIT 5;
```

This query first filters the sales records to only include sales that occurred in December 2021 using the `MONTH` and `YEAR` functions. It then groups the sales records by product ID and calculates the sum of sale amounts for each product. Finally, it orders the results by total sales in descending order and limits the output to the top 5 products.
Supponiamo di avere una tabella denominata &quot;sales&quot; con le colonne &quot;product_id&quot;, &quot;sale_date&quot; e &quot;sale_amount&quot;. Scrivi una query SQL per trovare i primi 5 prodotti con le vendite totali più elevate nel mese di dicembre 2021.