SQL Server Course for Beginners with 100+ examples - AVG() Function

The video tutorial demonstrates how to use the SUM function in SQL to calculate the total sum of a numeric column, specifically focusing on an employee salary column in a database. It covers viewing the employee table, calculating total salaries, and applying conditions to sum only salaries above a certain threshold.

What SQL command is used to retrieve all records from the employee table?

• SELECT * FROM employee;

• SELECT ALL FROM employee;

• GET ALL FROM employee;

• SHOW ALL FROM employee;

How can you calculate the total sum of salaries in the employee table?

• SELECT SUM(salary) FROM employee;

• SELECT TOTAL(salary) FROM employee;

• SELECT ADD(salary) FROM employee;

• SELECT SUMMATION(salary) FROM employee;

Explain how to use the SUM function in SQL to find the total of a numeric column.

Evaluate responses using AI:

OFF

What condition would you use to find the sum of salaries greater than or equal to 7000?

• WHERE salary >= 7000;

• WHERE salary > 7000;

• WHERE salary = 7000;

• WHERE salary <= 7000;

What is the expected output when calculating the sum of salaries above 7000?

• 32000

• 30000

• 35000

• 40000