List all sales transactions that occurred in the second quarter of 2023.
CREATE TABLE sales (sale_id INTEGER, sale_date DATE, amount DECIMAL); INSERT INTO sales (sale_id, sale_date, amount) VALUES (1, '2023-04-15', 100.50), (2, '2023-05-20', 200.75), (3, '2023-07-01', 150.00);
```sql
SELECT * FROM sales WHERE sale_date BETWEEN '2023-04-01' AND '2023-06-30';
```
```sql
SELECT * FROM sales WHERE sale_date BETWEEN '2023-04-01' AND '2023-06-30';
```