Query the max total count of tickets sold

I want to find the cinema with the max total number of tickets sold:

Find the penultimate activity for each user

I have a sample data like below:

How to get pivot with no specific pattern

I am looking for a way to handle following pivot situation.