Question

Consider the following table:

                     Table: SALESMAN

Scode	Sname	Area	Qtysold	Dateofjoin
S001	Ravi	North	120	2015-10-01
S002	Sandeep	South	105	2012-08-01
S003	Sunil	NULL	68	2018-02-01
S004	Subh	West	280	2010-04-01
S005	Ankit	East	90	2018-10-01
S006	Raman	North	NULL	2019-12-01

Predict the output for the following SQL queries:

1. SELECT MAX(Qtysold), MIN(Qtysold) FROM SALESMAN;
2. SELECT COUNT (Area) FROM SALESMAN;
3. SELECT LENGTH (Sname) FROM SALESMAN WHERE MONTH(Dateofjoin)=10;
4. SELECT Sname FROM SALESMAN WHERE RIGHT(Scode,1)=5;

Answer 1

1. 280        68
2. 5
3. 4
   5
4. Ankit