Question
Write a query to find the total salaries of all the employees in each department. Employees that are not in a department should appear as
Write a query to find the total salaries of all the employees in each department. Employees that are not in a department should appear as being in the department "None" Order the results alphabetically by department name Do not display any departments that have a total salary of 30000 or greater
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Structure Of The Relational Database Model
Authors: Jan Paredaens ,Paul De Bra ,Marc Gyssens ,Dirk Van Gucht
1st Edition
3642699588, 978-3642699580
