please help me solve this query using my data, thank you

Ppts 2. Write a query to show best-selling products (IDs, product name, and Sold quantity). Show top five best-selling products. Sort by sold quantity in descending order. 5pts select from order lines; select from orders, select * from payment method, select * from product inventory Query Result x SQL | Fetched 50 rows in 0.045 seconds ORDER_ID PRODUCT_ID ACTUAL PRICE 1 508 1278 8927.57 DISCOUNT QUANTITY TOTAL_AMOUNT 26 1 6606.4 2. 1278 1159 4621.11 63 6 10258.86 3 1320 1192 19037 17 18 284412.78 4 1320 1235 19624.49 30 23 315954.29 5 1320 1141 73 16 2083.49 482.29 509.08 6 1923 1221 17 1 422.54 7 1923 1244 509.08 54 20 4683.54 8 1874 1147 1281.39 56 24 13531.48 9 2001 1143 3209.39 12 17 48012.47 10 2468 1231 20859.66 29 22 325827.89 11 3566 1031 1869826 77 17 73110.2 12 3571 1209 20472.69 55 2 18425.42 80166.64 13 3571 1120 11859.97 48 13 14 3576 1240 243721 40 9 13160.93 15 3576 1167 1585251 5 5 75299.42 16 3677 1188 3 11 86987.82 8152.56 6629.15 17 4241 1186 71 10 19224.54 18 5329 1247 2 4 13494.56 3442.49 14029.8 19 3953 1012 36 2 17958.14 20 4702 1197 20787.76 0 22 457330.72 select from products; select * from shipment method; G select c. First Name I c.Last Name As Customer Name", count(*) As "Total Orders" from customers c, orders o where c.customer_id = o. customer id group by c. First_Name, c.Last Name order by C. Last Name: Query Result x 1 2 3 4 5 6 8 9 SQL | Fetched 50 rows in 0.051 seconds PRODUCT ID CATEGORY_ID PRODUCT NAME PRODUCT DESC 1113 6 Product medical equipments1113 b_7a2:K1vMuqi4qJR+2^8] NE9v) ThsIMBSJUW 1114 1 Product hardwarell14 CEO) =@kd82IB:40Jkre8c.hX: HQ22Yw63 PHMlg 1115 17 Product books1115 zkrp7 | eM@L$D5- 1117 14 Product shoes1117 1"6Ak9: LUodl=KQaEPCyPhoYI4g)"019$JJ? 1118 3 Product appliances1118 Oe!)5KhjEms-WS0"k=/Euu0AQ""$$vdn=Aorx' 1119 7 Product equipmentsl119 ZL+FojMQy\ O*uHQP>$8d[32pn@C+7FY)_YDMm=, VY3@h=!i95CIeC; lmR/hK;^+ eX/:1 1124 11 Product materials1124 d;I3ALUK!Me\3^KE 70042*@T5 Vd3F @T 1127 4 Product apperall127 W:T) (Q[I*n;+cV69-7A9SrvvEk/AH1IBHMN4q90CAwv_#2N@.=W 1130 4 Product apperal1130 27-L2.3rg? 'Let2G2\] OER#1 2cp7#AEW, KJZta-5 1131 7 Product equipmentsl131 5-wlwlP5) LIIDEE+M_-"|XziQNH=Opq*o$tb?eVavu 1132 1 Product hardware1132 @xQu-,>mE5Gb () k-AW=K-3r KF. +B) W [IKUmjn 24 10 11 12 13 14 15 16 17 18 19 20 NU w select from product_inventory select from products: select from shipment method, select c. First Namella. Last Name As mugtomer Name count() As Total Or from customers c, orders o where c.customer_id = o. customer id group by c. First Name, c.Last Name order by c. Last Name: Query Result x 1 2 3 4 5 6 7 8 9 SQL | Fetched 50 rows in 0.052 seconds PRODUCT_ID QTY_ON_HAND QTY ON ORDER DATE ORDERED DELIVERY DATE 1000 65 26 22-MAR-01 17-JUN-01 1001 62 82 25-OCT-99 05-NOV-99 1002 97 47 18-DEC-98 02-FEB-99 1003 95 42 28-FEB-99 01-MAR-99 1004 15 24 28-NOV-98 10-FEB-99 1005 37 10 11-MAR-99 30-MAR-99 1006 72 30 04-APR-99 01-JUN-99 1007 63 88 12-APR-00 13-APR-00 1008 59 22 09-NOV-02 26-JAN-03 1009 37 89 17-JAN-02 27-FEB-02 1010 31 33 02-APR-00 30-APR-00 1011 15 35 16-JUN-98 22-JUN-98 1012 58 12 18-FEB-99 13-APR-99 1013 22 34 25-APR-02 29-MAY-02 1014 56 6 02-OCT-99 25-OCT-99 1015 71 13 26-MAR-02 16-MAY-02 1016 69 78 20-DEC-00 18-JAN-01 1017 32 90 18-JUL-00 28-AUG-00 1018 57 32 10-MAR-02 26-APR-02 1019 45 62 09-JUL-01 05-AUG-01 11 13 14 8 6 5 5 5 5 5 15