w3resource
SQL exercises

SQL Exercises: Find the sum of the allotment amount of all departments

SQL Aggregate Functions: Exercise-24 with Solution

Write a query in SQL to find the sum of the allotment amount of all departments.

Sample table: emp_department


Sample Solution:

SELECT SUM(dpt_allotment) 
FROM emp_department;

Sample table: emp_department


Output:

SQL Join Exercise

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

Practice Online


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

Previous: Write a SQL query to display the average price of each company's products, along with their code.
Next: Write a query in SQL to find the number of employees in each department along with the department code.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming