Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Each record in the table department represents a department which might hire some employees. Each record in the table employee represents an employee who works

Each record in the table department represents a department which might hire some employees. Each record in the table employee represents an employee who works for one of the departments from the table department . The salary of each employee is known .( However , the locations of the departments are not relevant here .) Write an SQL query that returns a table comprising all the departments () in the table department that hire at least one employee , the number of people they employ and the sum of salaries in each department . The table should be ordered by ( increasing order ). For example , for :

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

Intelligent Information And Database Systems Second International Conference Acids Hue City Vietnam March 2010 Proceedings Part 1 Lnai 5990

Authors: Manh Thanh Le ,Jerzy Swiatek ,Ngoc Thanh Nguyen

2010th Edition

3642121446, 978-3642121449

More Books

Students also viewed these Databases questions