[Solved] Consider this query:SELECT * FROM Sales PIVOT (SUM(Amount) FOR Month IN ('Jan', 'Feb', 'Mar')) AS p;What will this query do? | SQL

SQL - Advanced Query Patterns

Consider this query:

SELECT * FROM Sales PIVOT (SUM(Amount) FOR Month IN ('Jan', 'Feb', 'Mar')) AS p;

What will this query do?

AUnpivot the Month columns into rows.

BCreate columns Jan, Feb, Mar with summed Amounts for each group.

CReturn an error because Month values are strings and need casting.

DFilter rows where Month is Jan, Feb, or Mar.

Step-by-Step Solution

Solution:

Step 1: Analyze PIVOT usage
PIVOT aggregates Amount by Month, creating columns for Jan, Feb, Mar.
Step 2: Check options
Create columns Jan, Feb, Mar with summed Amounts for each group. correctly describes the result. Others describe errors or wrong operations.
Final Answer:
Create columns Jan, Feb, Mar with summed Amounts for each group. -> Option B
Quick Check:
PIVOT creates columns with aggregates [OK]

Quick Trick: PIVOT sums values into new columns [OK]

Common Mistakes:

Master "Advanced Query Patterns" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider this query: