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. At least two aggregate functions are 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 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's name implies the average over all values. For example, if you have a price field in your table and want to know what the average price is on all items, you would use this SQL statement:

Do you need a similar essay? Click Order Now and get a qualified writer for high-quality papers

You can leave a response, or trackback from your own site.
error: Content is protected !!