I have a table saving dates things were done by a boolean value after a date. I need to query this to run a report that tells me the date each of the most recent columns was done. So the table looks like this:

```
id item date        sweep dust vacuum wash
1   1   2021-01-01    t
2   1   2021-02-02          t      
3   1   2021-03-03    t          t 
4   1   2021-04-04                     t
5   1   2021-05-05    t     t
6   1   2021-06-06               t

```

The report needs to be like:

```
TASK     MOST RECENT
sweep    2021-05-05
dust     2021-05-05
vacuum   2021-06-06
wash     2021-04-04

```

I'd like to figure out the most efficient way to query for this so I can display the dates in a datatable as I have up to potentially 100,000 items in the database I'll be tracking.

Note: It's possible I can change how the date/task data is stored if needed for efficiency of reporting.