sql 聚合用户最近购买的水果，并且转成字符串

WITH finishers AS
 (SELECT 'Sophia Liu' as name,
  
  'F30-34' as division ,'apple' as fruit
  UNION ALL SELECT 'Lisa Stelzner',  'F35-39','pear'
  UNION ALL SELECT 'Nikki Leith',  'F30-34'  ,'banana'
  UNION ALL SELECT 'Lauren Matthews', 'F35-39','grape'
  
  UNION ALL SELECT 'Lisa Stelzner',  'F35-34','kiwi'
  UNION ALL SELECT 'Nikki Leith',  'F30-24'  ,'orange'
  
  UNION ALL SELECT 'Lisa Stelzner',  'F35-39','melon'
  
  UNION ALL SELECT 'Lauren Matthews', 'F35-39','cherry'

 )
  
select string_agg(fruit ,',') as agg_fruit   from finishers  group by  name

行	agg_fruit
1	apple
2	pear,kiwi,melon3
3	banana,orange
4	grape,cherry