"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;