[Solved] Given the table Sales with rows:Product | QuantityApple | 10Banana | 5Apple | 15What is the result of the query:SELECT SUM(Quantity) FROM Sales WHERE Product = 'Apple'; | SQL

SQL - Aggregate Functions

Given the table Sales with rows:

Product | Quantity
Apple   | 10
Banana  | 5
Apple   | 15

What is the result of the query:
SELECT SUM(Quantity) FROM Sales WHERE Product = 'Apple';

A10

B15

C25

D30

Step-by-Step Solution

Solution:

Step 1: Filter rows where Product = 'Apple'
Rows matching: Apple with Quantity 10 and Apple with Quantity 15.
Step 2: Sum the Quantity values for these rows
10 + 15 = 25.
Final Answer:
25 -> Option C
Quick Check:
10 + 15 = 25 [OK]

Quick Trick: Sum only filtered rows matching condition [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table Sales with rows: