Answer to Question #128582 in Databases | SQL | Oracle | MS Access for xynom bhujel

Question

List the reason code, reason description, block code, block minutes for the appt detail row with the highest number of minutes in each appointment. Show the minutes formatted as “# minutes” and use the following column headings: Reason Code, Description, Block Code, Minutes. Hint: use a GROUP by and nested SELECT.
In oracle

Answer 1

Dear xynom bhujel, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order