20 (1 point) Using the SP database, we are interested to know which supplier total shippment is greater than the average shippment by all supplieres. We also want to show avaerage from all suppliers and the difference of a supplier shppment from average all suppliers shippment sample result is listed below S# SUP_AVG AVG_ALL_SUP DIFF_SHIP -- ------- ----------- --------- S2 350 258.33 91.67 S4 300 258.33 41.67 Which of thw following SELECT statements could lead us to the correct result: A select s#, avg(qty) sup_avg ,(SELECT avg(qty)AVG FROM SP) AVG_All_Sup , (avg(qty)-(SELECT avg(qty)AVG FROM SP)) Diff_Ship B select s#, avg(qty) sup_avg ,(SELECT avg(qty)AVG FROM SP) AVG_All_Sup , (avg(qty)-(AVG_All_Sup) Diff_Ship C select s#, avg(qty) sup_avg ,(SELECT avg(qty)AVG FROM SP) AVG_All_Sup , (sup_avg-(AVG_All_Sup) Diff_Ship D A, B, and C are correct Question 20 options: A B D c