what you're asking for is called a "crosstab" layout
this is not a task that the database engine should be asked to perform
to give you a feeling for why, it's because in order to have separate columns for each event, you would have to hardcode the conditional expression for each column in the sql, and this is bloated, awkward and prone to error (i mean, look, you started out talking about 3, then suddenly there were 8...)
do the crosstab in your application language (php or whatever)