41) Write a query to display the list of student ids and average marks in 2 decimal places if their average mark is greater than 80. Give an alias to the average mark as AVG_MARK. Sort the result based on the average mark in ascending order.
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.
Comments
Post a Comment