Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the maximum and minimum salary of current employee and their department name grouped by department. I have this answer below in pic, but when

List the maximum and minimum salary of current employee and their department name grouped by department.
I have this answer below in pic, but when I check the answer in this link it's not the write answer!!
http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=9
image text in transcribed
select d.DName, Max (.Salary) as "Max Salary", MIN (J.Salary) as "Min salary" from jobhistory , Employee e, Depatment d where e, EmpNo=j. EmpNo , and d. DepNo e. DepNo and j.enddate is null group by d.DName,j.Salary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

Solve. 2x 2 + 6 = -7x

Answered: 1 week ago

Question

1. Television more Over watching faceing of many problems ?

Answered: 1 week ago

Question

Is there a link between chronic stress and memory function?

Answered: 1 week ago

Question

What is DDL?

Answered: 1 week ago