Find the average sales amount for each product, truncating the average to the nearest integer, and then list only those products where the truncated average is greater than 200.
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), (3, 100.00), (3, 150.00);
```sql
SELECT product_id, TRUNC(AVG(sales_amount)) AS avg_sales
FROM sales
GROUP BY product_id
HAVING TRUNC(AVG(sales_amount)) > 200;
```
```sql
SELECT product_id, TRUNC(AVG(sales_amount)) AS avg_sales
FROM sales
GROUP BY product_id
HAVING TRUNC(AVG(sales_amount)) > 200;
```