I have a table which has events and the day they occurred:

Table 'Events': 

```
Name  Day
-----------
A     1
B     2
A     2
B     3

```

I need output columns to be a date range based on query input with rows being which event happened on the day so:

Desired output:

```
Day-1 Day-2 Day-3
-----------------
A     A     -
-     B     B

```

If this is possible can anyone give me a sample query that could generate this output based on a date range. There are all sorts of I have no clue how to even approach this issues here like an unknown number of columns.