How to Get the Latest Row per Group in MySQL 8 Using ROW_NUMBER()

Introduction I sometimes need to get the latest row for each group in MySQL: the most recent login per user, the latest status per order, or the last edit per article. For MySQL 8.0 and later, ROW_NUM