select name,(name,1,3||phone_no,1,3)from users order by (name); : I'm writing a query for the above problem and it is showing error.
Write a to display user name and password. Password should be generate by concatenate first three characters of user name and first three numbers in phone number and give an alias name as password. Sort the result based on user name