Question

Consider the following table: PRODUCT

                Table: PRODUCT

PID	PNAME	PRICE	QUANTITY
P1001	Eraser	10.50	5
P1002	Ball Pen	15.00	2
P1003	Gel Pen	25.10	3
P1004	Ruler	5.00	1

Find the output of the following SQL queries:

1. SELECT 10+MOD(QUANTITY,3) FROM PRODUCT WHERE PNAME = "Eraser";
2. SELECT ROUND(PRICE,2)*QUANTITY FROM PRODUCT WHERE QUANTITY>2;
3. SELECT UCASE(RIGHT(PNAME,2)) FROM PRODUCT;

Answer 1

1. 12
2. 52.50
   75.30
3. ER
   EN
   EN
   ER