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

## Practice Online

## Query Visualization:

**Duration:**

**Rows:**

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

**Weekly Trends and Language Statistics**- Weekly Trends and Language Statistics