What is the generated SQL of that expression? This is indeed a sticky problem, one that usually requires a subselect or other workaround to address the non-det

What is the generated SQL of that expression? This is indeed a sticky problem, one that usually requires a subselect or other workaround to address the non-determinism of group by + order by; i.e. one cannot simply "select * from employees group by role order by join_date limit 1" and be guaranteed to get the expected ordering.