Explode a name into one row per word

The inverse of aggregation: one row becomes many. Split each customer's full_name on spaces and return one row per word. Columns: customer_id, word. Sort by customer_id, then word.

Tables & sample data

customers

7 rows total · first 5 shown

customer_idvarchar	signup_tstimestamp with time zone	countryvarchar	segmentvarchar	phonevarchar	full_namevarchar
c_001	2026-05-01 09:00:00	IN	premium	+91-9876543210	Ananya Sharma
c_002	2026-05-03 11:30:00	US	premium	+1-415-555-0123	Brad Miller
c_003	2026-05-05 14:15:00	IN	free	NULL	Chen Wei
c_004	2026-05-10 08:45:00	UK	free	+44-20-7946-0958	Dhruv Patel
c_005	2026-05-12 16:00:00	US	premium	NULL	Elena Garcia

query.sql

Loading editor…