w3resource

AdventureWorks Database: Find average bonus for salespersons achieved quota above 25000

SQL Query - AdventureWorks: Exercise-92 with Solution

92. From the following table write a query in SQL to find the average bonus for the salespersons who achieved the sales quota above 25000. Return number of salespersons, and average bonus.

Sample table: Sales.SalesPerson


Click to view Full table

Sample Solution:

SELECT COUNT(*), AVG(Bonus)  
FROM Sales.SalesPerson  
WHERE SalesQuota > 25000;

Sample Output:

count|avg                  |
-----+---------------------+
   14|3472.1428571428571429|

SQL AdventureWorks Editor:

Practice Online


Contribute your code and comments through Disqus.

Previous: Find the total number of employees.
Next: Return maximum, minimum, average salary and total employees for each department.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.