Which of the following is the correct syntax to get the total sales from a table named Orders with a column Amount?

easy📝 Syntax Q12 of 15

SQL - Aggregate Functions

Which of the following is the correct syntax to get the total sales from a table named Orders with a column Amount?

ASELECT COUNT(Amount) FROM Orders;

BSELECT TOTAL(Amount) FROM Orders;

CSELECT SUM(Amount) FROM Orders;

DSELECT ADD(Amount) FROM Orders;

Step-by-Step Solution

Solution:

Step 1: Identify the correct aggregation function for total
The function to add values is SUM(), so SUM(Amount) is correct.
Step 2: Check syntax correctness
SUM(Amount) with SELECT and FROM table is valid SQL syntax.
Final Answer:
SELECT SUM(Amount) FROM Orders; -> Option C
Quick Check:
SUM() sums values [OK]

Quick Trick: Use SUM() to add values in SQL [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes