I'm trying to create a pivot in MC but keep getting an error when saving SQL can you confirm if MC support pivots? the error i'm getting is "An error occurred while checking the query syntax. Errors: Error while parsing query. Please check the syntax"
SELECT SubscriberKey,Month FROM PH_TOTAL_BOUNCES PIVOT ( SubscriberKey FOR [month] IN (December,January,February, March,April,May) ) AS pvt