Question: Write an Sql query that returns department that hire atleast one employee, the number of people they employ and sum of salaries in each department

Write an Sql query that returns department that hire atleast one

Write an Sql query that returns department that hire atleast one employee, the number of people they employ and sum of salaries in each department department dept_id dept_name dept_location 10 DI India 20 CAD India 40 REPA Singapore 30 UA China 50 IT Australia employee 30/ 401 emp_id emp_name dept_id salary 1 Max 201 50001 2 Jane 150001 3 Elle 25000 4 KC 201 7500 5 Arun 20 15000 6 KK 10 12000 7 Bob 201 35000 8 Meera 30 25000 9 Jim 40 5000 Query output dept_id count sum_of_salary 10 12000 62500 40000 30000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write a Python program to query a MySQL database and print the query results. Details: Put a comment at the top of the Python file called lab7q1 with your name and student number. (0.5 mark) Make a...

You are given two tables, department and employee, with the following structure: create table department ( dept_id integer not null, dept_name varchar(3e) not null, dept_location varchar(30) not...

Please i need a SQL query if possible 1) Display all employee names (last name and first name separated by a comma and a space) and salary with appropriate column aliases. Also, for yearly salary...

Create HR database with the following tables. Write SQL query for the following questions based on above database. No. Question 1. Write a SQL query to find those employees whose salaries are less...

GA: 3 . 4 . Departments with the highest number employees! Employee Department Salary _ Grade Name Type empID INT empName VARCHAR ( 2 5 5 ) jobTitle VARCHAR ( 1 0 0 ) managerID INT hireDate DATE...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

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...

ber81438_exr_001-068.qxd 8/11/09 7:38 PM Page 51 EXERCISE 10.3: D EVELOPING AN E MPLOYEE B ENEFITS P ROGRAM * Overview Chapter 10 provides an overview of types of employee benefits programs. The...

Under each requirement listed below, please write just ONE select, update or insert statement to meet that re- quirement. Although they are not needed, you may use spe cial functions in the SQL92...

Best Stores is considering a change in its inventory valuation method. The company currently uses the FIFO method and may want to change to the LIFO method. Inventory information for the current year...

Describe the appearance of the 1H NMR spectrum of each of the following compounds. How many signals would you expect to find, and into how many peaks will each signal be split? (a) 1,...

An instance variable refers to a data value that a . is owned by a particular instance of a class and no other b . is shared in common and can be accessed by all instances of a given class c . is...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Comprehend the trade-offs among the various approaches to designing jobs. page 175

Discuss the roles, responsibilities, and requirements of the federal agencies responsible for enforcing equal employment opportunity laws. page 111

Choose the right job analysis technique for a variety of human resource activities. page 165