“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.