Can Oracle have multiple group functions in the same SELECT list of a query (i.e can we do a COUNT and an AVG)?
Let's suppose we wanted to find the lowest, highest, average, and total number of salaries by department in a company. What SQL query would give us this, in the most meaningful format, assuming that we have two tables of EMPLOYEES and DEPARTMENTS and that they are related thru the Dept_ID column?