SQL Exercises: Calculate the total allotment for all departments

Last update on February 11 2025 08:00:48 (UTC/GMT +8 hours)

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 Tree:

Practice Online

For more Practice: Solve these Related Problems:

• Write a SQL query to compute the sum of the allotment amount for departments with an allotment amount greater than 50000.
• Write a SQL query to compute the sum of the allotment amount for departments with an allotment amount less than 100000.
• Write a SQL query to compute the sum of the allotment amount for departments with an allotment amount between 50000 and 100000.
• Write a SQL query to compute the sum of the allotment amount for departments with an allotment amount greater than 100000.

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.