Sql query to determine lowest, highest, average salary

Assignment Help Computer Engineering

Reference no: EM1322946

Specify whether Oracle can have several group functions in the same SELECT list of the query (i.e can we do a COUNT and an AVG)?

Let's assume that we wanted to determine the lowest, highest, average and total number of the salaries by department in company. What SQL query would provide us this, in the most meaningful format, supposing that we have two tables of EMPLOYEES and DEPARTMENTS and that they are related through the Dept_ID column?

Reference no: EM1322946

Questions Cloud

Designing the dfd : Construct a context diagram for the new system. Construct a diagram 0 DFD for the new system.

Determinant of demand changes in the personal computer : Which determinant of demand changes in the personal Computer marketplace as more persons become interested

Probability distribution problem regarding businessman : At a board meeting of 20 businessmen, all of whom wear ties, what is the probability that:

Write an equation for a typical production function : Write an equation for a typical production function also illustrate what every of the terms represents.

Sql query to determine lowest, highest, average salary : Let's assume that we wanted to determine the lowest, highest, average and total number of the salaries by department in company. What SQL query would provide us this.

What does this imply as regards international trade theory : By signing a trade agreement illustrate what does this imply as regards international trade theory of the Ricordian model.

Dress habits-probability research : At a board meeting of 20 businessmen, all of whom wear ties, what is the probability that:

Program for calling the function : Suppose the availability of class named DataTransmitter which offers a static method, sendSignal which takes no arguments. Write down the code for calling this method.

Examining statistical information and output of simulation : After 1,000-trial simulation, examine statistical information generated and compare output of simulation with your findings in Problem .Briefly describe the significant similarities and differences.

User Account

All Pages