Logged in / Logged off

Content

I've been asked to have a list of accounts that shows "logged in / logged off" for all accounts and then show the last time logged in (or off)

I got somewhat annoyed at it showing the two rows per account if I used the user_trans table and all I wanted to know out of say 100 people who was logged in, who was logged out. I moved to the account_session_history table and then got annoyed with the "max" command. Long story short I had to have a 2 next to Logged in and a 1 next to Logged Off to allow this to work as it seems that it's using a "max" on the logged in/ logged out and because "out" is after "in" alphabetically it throws a