CODE EXAMPLE FOR SQL

SQL Query Orderby Two or More Columns and by number of characters

SELECT *
FROM table_name
ORDER BY RIGHT(name, 3) ASC, LEFT(town, 2);