Calculate the total sales for each product, truncating the sales amount to the nearest integer.
CREATE TABLE sales (product_id INTEGER, sales_amount DECIMAL(10,2)); INSERT INTO sales (product_id, sales_amount) VALUES (1, 123.45), (1, 234.56), (2, 345.67), (2, 456.78);
```sql
SELECT product_id, SUM(TRUNC(sales_amount)) AS total_sales
FROM sales
GROUP BY product_id;
```
```sql
SELECT product_id, SUM(TRUNC(sales_amount)) AS total_sales
FROM sales
GROUP BY product_id;
```