[Solved] Given the table Inventory with rows:Item | StockPen | 12Book | 8Pen | 5What is the result of:SELECT SUM(Stock) FROM Inventory WHERE Item = 'Pen';? | SQL

SQL - Aggregate Functions

Given the table Inventory with rows:

Item | Stock
Pen  | 12
Book | 8
Pen  | 5

What is the result of:
SELECT SUM(Stock) FROM Inventory WHERE Item = 'Pen';?

A17

B12

C5

DNULL

Step-by-Step Solution

Solution:

Step 1: Identify rows matching condition
Rows where Item = 'Pen' are 12 and 5.
Step 2: Apply SUM() on filtered rows
Sum = 12 + 5 = 17.
Final Answer:
17 -> Option A
Quick Check:
Sum of Pen stock values is 17 [OK]

Quick Trick: SUM() adds only filtered rows [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 Inventory with rows: