Column Arithmetic
sql
1SELECT name, marks, marks + 10 AS bonus_marks FROM students;
2
3SELECT name, marks * 1.1 AS curved_marks FROM students;Operators
| Operator | Meaning |
|---|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| % | Modulo |

1SELECT name, marks, marks + 10 AS bonus_marks FROM students;
2
3SELECT name, marks * 1.1 AS curved_marks FROM students;| Operator | Meaning |
|---|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| % | Modulo |