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

Based on the given table SALESMAN Write SQL queries to perform the following operation:

1. Count the total number of salesman.
2. Display the maximum qtysold from each area.
3. Display the average qtysold from each area where number of salesman is more than 1.
4. Display all the records in ascending order of area.

Answer 1

1. SELECT COUNT(Sname) FROM SALESMAN;
2. SELECT Area, MAX(Qtysold) FROM SALESMAN GROUP BY Area;
3. SELECT Area, AVG(Qtysold) FROM SALESMAN GROUP BY Area HAVING COUNT(*)>1;
4. SELECT * FROM SALESMAN ORDER BY Area;