Arithmetic Operators

☞ It is used in arithmetic calculations and expressions.

☞ Following are the mathematical operators : +, -, *, /, %, **

☞ Syntax :

SELECT <column_1> <operator(+, -, *, /, %, **)> <value_1>
FROM <table_name>;

☞ Example :

SELECT fees + 100 FROM student;

OR

SELECT fees + 1000 AS total_fees
FROM student;