﻿ SQL: Calculate the total allotment for all departments

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

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

﻿