45) Write a query to display the courier details such as courier id, from address, to address and the status of the couriers delivered in the month of 'January'. Sort the records based on to address in ascending order.
52) Write a query to display the courier id, contact number of the from branch with the alias name 'CONTACT_FROM_BRANCH' and contact number of the delivered branch with the alias name 'CONTACT_TO_BRANCH'. Sort the records based on the courier id in descending order.
Comments
Post a Comment