Write a query to display the customer name and customer code of all customers who use 'yahoo' as their email. The customer code should be generated by concatenating the first $3$ characters of the customer's name and the first $3$ numbers of their contact number. Give an alias name as 'CUSTOMER$\_$CODE'.

Sort the results based on the customer address in ascending order.

Sample data:

Customer Name: Holder

Contact Number:$9506161140$

Sample Output:

CUSTOMER$\_$CODE

Hol$950$