ARITHEMATIC OPERATIONS IN QUERIES ?

ADDITION

SELECT COLOUMN NAME+1000  FROM TABLE NAME;

To give new name to the operated coloumn

SELECT COLOUMN NAME +1000 NEW COLOUMN NAME FROM TABLE NAME;

SUBTRACTION

SELECT COLOUMN NAME-10 FROM TABLE NAME;

MULTIPLICATION

SELECT COLOUMN NAME *10 FROM TABLE NAME;

DIVISION 

SELECT COLOUMN NAME /10 FROM TABLE NAME;