SUM function in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the total salary from the employees table.

MySQL

SELECT SUM([1]) FROM employees;

Drag options to blanks, or click blank then click option'

Aname

Bsalary

Cdepartment

Demployee_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like name or department inside SUM.

Forgetting to specify the column inside SUM.

The SUM function adds up all values in the specified column. Here, we want to sum the salary column.

2fill in blank

medium

Complete the code to find the total sales from the orders table.

MySQL

SELECT SUM([1]) FROM orders;

Drag options to blanks, or click blank then click option'

Aorder_date

Border_id

Ccustomer_id

Dtotal_amount

Attempts:

3 left

💡 Hint

Common Mistakes

Using a date or ID column inside SUM.

Confusing column names that do not hold numeric values.

The SUM function should be used on the column that holds the sales amount, which is total_amount.

3fill in blank

hard

Fix the error in the code to correctly sum the prices in the products table.

MySQL

SELECT SUM([1]) FROM products;

Drag options to blanks, or click blank then click option'

Aprice

Bproduct_name

Ccategory

Dstock

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to sum text columns like product_name or category.

Using a column that is not numeric.

The SUM function must be used on a numeric column like price. Using product_name or category causes errors because they are text.

4fill in blank

hard

Fill both blanks to calculate the total quantity sold for product_id 101 in sales table.

MySQL

SELECT SUM([1]) FROM sales WHERE [2] = 101;

Drag options to blanks, or click blank then click option'

Aquantity

Bprice

Cproduct_id

Dcustomer_id

Attempts:

3 left

💡 Hint

Common Mistakes

Summing the price instead of quantity.

Filtering by the wrong column in WHERE clause.

We sum the quantity column to get total units sold. The WHERE clause filters rows where product_id equals 101.

5fill in blank

hard

Fill all three blanks to calculate the total revenue for customer 'John' in orders table.

MySQL

SELECT SUM([1]) FROM orders WHERE [2] = '[3]';

Drag options to blanks, or click blank then click option'

Atotal_amount

Bcustomer_name

CJohn

Dorder_date

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong columns in SUM or WHERE clause.

Forgetting to put quotes around the string 'John'.

We sum the total_amount column to get revenue. The WHERE clause filters orders where customer_name is 'John'.