69) The courier manager decides to create a new courier code for the courier which was booked after '31-03-2020'. The courier code should be created by adding the first three letters of the from address, followed by the first two letters of the courier id and the first three letters of the to address. The courier code should be in upper case. Write a query to display courier details like courier id, branch id and courier code. Give an alias name for the courier code as 'COURIER_CODE'. Sort the results based on the booking date in ascending order.
Comments
Post a Comment