SESSION NAME: SQL Functions - 1.

QUESTION NAME: Arithmetic Operations.


TABLE DESCRIPTION:
Perform Arithmetic Operations.

Display all the details from the items_ordered table by
using (select * from items_ordered table).


Perform arithmetic query by adding 113 in customer id
filed, multiply 50 in quantity, reduce the price by 50 and
divide the customer id by 100 respectively and duly.


customerid+113
quantity*50
price-50
customerid/100

CODE:
select customerid+113,quantity*50,price-50,customerid/100  from items_ordered;