[Solved] Given the table fruits with rows: ('apple'), ('banana'), ('cherry'), what is the result of this query?SELECT STRING_AGG(name, '; ' ORDER BY name) FROM fruits; | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Given the table fruits with rows: ('apple'), ('banana'), ('cherry'), what is the result of this query?

SELECT STRING_AGG(name, '; ' ORDER BY name) FROM fruits;

A'apple; banana; cherry'

B'banana; apple; cherry'

C'cherry; banana; apple'

D'apple, banana, cherry'

Step-by-Step Solution

Solution:

Step 1: Understand ORDER BY inside STRING_AGG
The query orders names alphabetically: apple, banana, cherry.
Step 2: Check separator and output
Separator is '; ', so the result joins names with '; ' in order.
Final Answer:
'apple; banana; cherry' -> Option A
Quick Check:
Ordered join with '; ' separator = 'apple; banana; cherry' [OK]

Quick Trick: ORDER BY inside STRING_AGG sorts before joining [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table fruits with rows: ('apple'), ('banana'), ('cherry'), what is the result of this query?