SQL: Create pivot table to aggregate data by month and year from timestamp

Question

I have 3 columns in my data set.

• email
• first name
• unsubscribe date (timestamp)

How can i create a pivot table in SQL to have years on the left in rows, and months in columns and count the number of people who unsubscribed by month and year?

Thanks for the help

Answer 1

Unfortunately, you can't. Timestamp is poorly named, and has nothing to do with the time the person unsubscribed.