clean.sql

select
    strptime(message_date, '%Y-%m-%d %H:%M:%S') as message_date,
    chat,
    text,
    -- customized to my friends
    case
        when
            is_from_me = 1
            then 'Izzy'
        when
            id = 'REDACTED'
            then 'Harvey'
        when
            id = 'REDACTED'
            then 'Kiebs'
        when id = 'REDACTED' then 'Henry'
        when id = 'REDACTED' then 'Luke'
        when id = 'REDACTED' then 'Wyatt'
        when id = 'REDACTED' then 'Luke'
        when id = 'REDACTED' then 'Harvey'
    end as sender
from chats
order by message_date asc