week 2 discussion 2

"Aggregate Queries" Please respond to the following:

• Suppose you have been hired as an IT professional to support database reporting functionality for a Human Resources system.  Compose at least two aggregate function queries that can be useful for the executives of the organization to extract summary data from a database system.  
• Synthesize how aggregate functions help the organization understand employee performance. Provide an example that supports how the aggregate function is used to leverage talent within the organization. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.  
• It would be great if you can provide the SQL statements that will use your two aggregate functions that you selected.

Here is an example of a classic SQL aggregate function: the avg() function (average). The avg() as it name implies determines the average over all values. For example, if you a price field in your table and wanted to know what is the average price over all items, you would use this SQL statement:

SELECT AVG(price) FROM items;