(Solved): Task 3.2.3. Find the difference between the maximum and average quantity for purchase order items ( ...

Task 3.2.3. Find the difference between the maximum and average quantity for purchase order items (po_item) used by each job id except '006'. Do not include the item with the id 'IWS'. Sort the result by the difference between the maximum and average quantity in descending order. HINT: change the aggregate function column to 'Difference'. Use the HAVING clause to exclude the job id. BIG HINT: One way to order on a column that uses an aggregate function is to specify the column position in the ORDER BY clause. For example: ORDER BY 4 will order on the forth column. See if you can find another way! For example: Answer: (penalty regime: \( 0 \% \) )