Question

The Quarter, Manager, Sales and DOB column of a table ‘SALE’ are given below : [3]

Quarter Manager Sales DOB

1 Naveen 15000 1990-12-31

2 Dilip NULL 1989-06-15

3 Nilesh 24000 1999-02-01

4 Praveen 12000 1995-01-16

Based on this information, find the output of following queries :

i. SELECT Sales + 500 FROM Sale WHERE Manager NOT LIKE ‘%n’;

ii. SELECT AVG(Sales) FROM Sale;

iii. SELECT YEAR(DOB), DAYOFYEAR(DOB) FROM Sale WHERE Quarter = 4;
​

Answer 1

Answer:

4 pravveen 12000 1995-01-16