Write sql query - display department names with salary grade, minimum salary and average commission. department with null commission display 0. subgrade table can be used to get the salary. use inner join . NVL for commision. joining with Sal grade table use iosal and hisal IN

Answer rating: 100% (QA)

Based on your requirements you can use the following SQL query to display department names with sa... View the full answer