Using the 'employees' table, which has columns 'employee_id', 'base_salary', and 'bonus', calculate the total salary for each employee by adding the base salary and bonus. The bonus is stored as a string, so you need to convert it to an integer before adding it to the base salary.
CREATE TABLE employees (employee_id INTEGER, base_salary INTEGER, bonus VARCHAR); INSERT INTO employees (employee_id, base_salary, bonus) VALUES (1, 50000, '10000'), (2, 60000, '15000'), (3, 70000, '20000');
```sql
SELECT employee_id, base_salary + CAST(bonus AS INTEGER) AS total_salary
FROM employees;
```
```sql
SELECT employee_id, base_salary + CAST(bonus AS INTEGER) AS total_salary
FROM employees;
```