in SQL Developer.

Display customer ID, customer name, and the order ID and the order date of all orders for customer whose ID is 44. a. Show also the total quantity and the total amount of each customer's order. b. Sort the result from the highest to lowest total order amount Customer Id Name 19 Order Id Order Date Total Items Total Amount 44 Jabil Circuit 9228-OCT-15 790 $1,050,939.97 44 Jabil Circuit 69 17-MAR-17 581 $755,093.92 44 Jabil Circuit 1024-JAN-17 883 $620,962.99 44 Jabil Circuit 2914-AUG-17 831 $508,588.59 44 Jabil Circuit 82 03-DEC-16 687 $398, 636.25 2 Display customer Id, name, total number of orders, the total number of items ordered, and the total order amount for customers who have more than 30 orders. Sort the result based on the total number of orders. 1 2 Customer idare 47 General Mills 8 International Paper 49 NextEra Energy 9 Emerson Electric 44 Jabil Circuit Total Member of Orders Total Items Total Amount 33 3116 $3,725, 138.14 3281 $2,642,238.04 37 3351 $2,452, 508.95 37 3301 $2,893,564.97 45 3772 $3,334,221.72 3 4 3 Display Warehouse Id, warehouse name, product category Id, product category name, and the lowest product standard cost for this combination. In your result, include the rows that the lowest standard cost is less then $200. Also, include the rows that the lowest cost is more than $500. Sort the output according to Warehouse Id, warehouse name and then product category Id, and product category name. Warehouse ID Warehouse Name Category Category Name Lowest Cost 1 Southlake, Texas 2 Video Card $535.03 2 San Francisco 2 Video Card $521.03 2 San Francisco 5 Storage $12.63 3 New Jersey 2 Video Card $535.03 4 Seattle, Washington 2 Video Card $535.03 5 Toronto 2 Video Card $521.03 5 Toronto 5 Storage $12.63 6 Sydney 2 Video Card $521.03 6 Sydney 5 Storage $12.63 7 Mexico City 2 Video Card $535.03 7 Mexico City 5 storage $12.63 8 Beijing 2 Video Card $535.03 8 Beijing 5 Storage $12.63 9 Bombay 2 Video Card $535.03 4 5 6 7 8 9 10 11 12 13 14