68) Write a query to display the branch id, courier id,from address,to address, weight and cost of the courier where the booking date is same as the expected delivery date. Sort the results based on the branch id 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