User email addresses and list of SKUs in their carts

SELECT c.id, c.email, STRING_AGG(cart.sku::text, ', ') AS skus FROM public.customer c JOIN public.carts cart ON c.id = cart.customer_id GROUP BY c.id, c.email;