Select all rows from the sales table where the total_amount rounded to 1 decimal place is greater than 100.50.
CREATE TABLE sales (sale_id INTEGER, total_amount NUMERIC); INSERT INTO sales (sale_id, total_amount) VALUES (1, 100.49), (2, 100.51), (3, 100.55);
```sql
SELECT * FROM sales WHERE ROUND(total_amount, 1) > 100.50;
```
```sql
SELECT * FROM sales WHERE ROUND(total_amount, 1) > 100.50;
```