Calculate the total sales amount for transactions that occurred in the year 2023.
CREATE TABLE sales (id INTEGER, amount DECIMAL(10,2), transaction_date DATE); INSERT INTO sales (id, amount, transaction_date) VALUES (1, 100.50, '2023-01-15'), (2, 200.75, '2022-12-20'), (3, 150.00, '2023-03-10');
```sql
SELECT SUM(amount) AS total_sales_2023
FROM sales
WHERE YEAR(transaction_date) = 2023;
```
```sql
SELECT SUM(amount) AS total_sales_2023
FROM sales
WHERE YEAR(transaction_date) = 2023;
```