Select Rows with Status that has Changed

select-rows-with-status-that-have-changed.sql

SELECT a.aws_account_id, a.name, a.description, a.refreshed, a.status
FROM
    athenatableforcsvs AS a
INNER JOIN
    athenatableforcsvs AS b
        ON a.aws_account_id = b.aws_account_id AND a.description = b.description
WHERE
    a.status <> b.status
GROUP BY a.aws_account_id, a.name, a.description, a.refreshed, a.status
ORDER BY 1, 2, 3, 4, 5;