Question

Find the range of salaries (min, max) of each department in the following table:
EMP(EID, ENAME, SAL, DEPT)
A) select min(sal), max(sal) from emp group by deptno;
B) select min(sal), max(sal) from emp group by dept;
C) select min(sal) as min, max(sal) as max from employees group by dept
D) select range(sal) from emp group by dept;

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: Using the SQL GROUP BY phrase with a SELECT statement can help detect which of thefollowing problems...

A: This question is based on SQL language . To know the right option of this question first a user must...

Q: Draw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen n...

A: Hey, since there are multiple questions posted, we will answer first question. If you want any speci...

Q: In Python Use the Design Recipe to write a function bools_2_str, which consumes a list of booleans a...

A: Create a Boolean list with true and false value such as:boolList = [True, True, False, True, False, ...

Q: Design a reasonably efficient algorithm for solving each of the following problems and determine its...

A: Algorithm to find who failed to pay telephone billFor finding who failed to pay telephone bill, firs...

Q: How does a honeypot fit in with the security provided by a firewall and intrusion detection system?

A: Honeypot in terms of cybersecurity:It is a part of the intrusion detection system and firewall that ...

Q: In C++ Language: Write a function SummOdd that will find the sum of all elements of add order a1+ a3...

A: As it is not clear in the question that sum of odd order for the arr[]={ 8,6,4,2,3,5} is 8 (3+5=8 i....

Q: How many lines does his algorithm print? Write a recurrence and solve it.function printaton(n: an in...

A: The given program splits into three subprograms with half of the input size each and then prints n^4...

Q: I have tried this  a few times and cannot figure it out. This is for python.

A: The sub lists can be printed by printing each row; hence the answer would be:for i in range(len(tabl...

Q: 3. Use a trace table to show what is the output of the following program? #include using namespace ...

A: As per the policy we are required to answer only one question.Solution for question 3 is as follows:...