Calculate the total sales for each product by adding the sales from two different quarters. The sales data is stored in the 'sales' table, which has columns 'product_id', 'q1_sales', and 'q2_sales'.
CREATE TABLE sales (product_id INTEGER, q1_sales INTEGER, q2_sales INTEGER); INSERT INTO sales (product_id, q1_sales, q2_sales) VALUES (1, 100, 150), (2, 200, 250), (3, 300, 350);
```sql
SELECT product_id, (q1_sales + q2_sales) AS total_sales
FROM sales;
```
```sql
SELECT product_id, (q1_sales + q2_sales) AS total_sales
FROM sales;
```