I'm trying to merge the values of two rows based on the value of another row in a different column. Below is my based table

Here is the SQL query I used

select customer_id, property_id, bookings_per_customer, cancellations_per_customer
from table

And this is what I want to see. Any ideas the query to get this would be? We use presto SQL

Thanks!

CodePudding user response：

We can try:

SELECT
    customer_id,
    ARRAY_JOIN(ARRAY_AGG(property_id), ',') AS properties,
    bookings_per_customer,
    cancellations_per_customer
FROM yourTable
GROUP BY
    customer_id,
    bookings_per_customer,
    cancellations_per_customer;