1 files changed, 3 insertions, 2 deletions
diff --git a/src/guff.cr b/src/guff.cr
index 7eb284a..6b842f8 100644
--- a/src/guff.cr
+++ b/src/guff.cr
@@ -1042,13 +1042,14 @@ module Guff
                  a.name,
                  a.email,
                  a.is_active,
-                 b.role
+                 b.role,
+                 b.name AS role_name
 
             FROM users a
             JOIN roles b
               ON (b.role_id = a.role_id)
 
-           ORDER BY LOWER(a.email)
+           ORDER BY LOWER(a.name)
         ",
       }