w3resource

SQL Exercises: Calculate the total allotment for all departments

SQL Aggregate Functions: Exercise-24 with Solution

From the following table, write a SQL query to compute the sum of the allotment amount of all departments. Return sum of the allotment amount.

Sample table: emp_department

DPT_CODE DPT_NAME        DPT_ALLOTMENT
-------- --------------- -------------
      57 IT                      65000
      63 Finance                 15000
      47 HR                     240000
      27 RD                      55000
      89 QC                      75000

Sample Solution:

-- This query calculates the sum of 'dpt_allotment' from the 'emp_department' table.
SELECT SUM(dpt_allotment)
-- Specifies the table from which to retrieve the data (in this case, 'emp_department').
FROM emp_department;

Output of the Query:

sum
450000

Code Explanation:

The query in SQL retrieves the sum of the values in the "dpt_allotment" column from the 'emp_department' table. The result will be a single value representing the total sum of the "dpt_allotment" column.

Relational Algebra Expression:

Relational Algebra Expression: Find the sum of the allotment amount of all departments.

Relational Algebra Tree:

Relational Algebra Tree: Find the sum of the allotment amount of all departments.

Practice Online


Query Visualization:

Duration:

Query visualization of Find the sum of the allotment amount of all departments - Duration

Rows:

Query visualization of Find the sum of the allotment amount of all departments - Rows

Cost:

Query visualization of Find the sum of the allotment amount of all departments - Cost

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous SQL Exercise: Compute the average price for unique companies.
Next SQL Exercise: Find out the number of employees in each department.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.