please help me with this query . fron oracle 19c

the table is call orders

select * from shipment method; Script Output * Query Result x 9 HE SQL | All Rows Fetched: 11 in 0.051 seconds SHIPMENT_METHOD_ID SHIPMENT_DESCRIPTION 1 Plane 2 2 Truck 3 Train 4 4 Car 1 NO 5 Fedex 6 UPS 7 Airborne 8 DHL 9 Priority Post 10 Special 11 Mail 7. Write a query to find the most popular shipment method. 5pts pts following items are unth 20 into each select * from product_Inventory: Script Output x Query Result x SQL | Fetched 50 rows in 0.06 seconds PRODUCT_ID QTY_ON_HAND QTY_ON_ORDER DATE_ORDERED DELIVERY_DATE 1012 58 12 18-FEB-99 13-APR-99 13 14 1013 22 34 25-APR-02 29-MAY-02 15 1014 56 6 02-OCT-99 25-OCT-99 16 1015 71 13 26-MAR-02 16-MAY-02 17 1016 69 78 20-DEC-00 18-JAN-01 18 1017 32 90 18-JUL-00 28-AUG-00 19 1018 57 32 10-MAR-02 26-APR-02 20 1019 45 62 08-JUL-01 05-AUG-01 22-OCT-01 21 1020 42 47 07-AUG-01 63 10-DEC-00 22 1021 22 24-DEC-00 23 1022 27 01-APR-02 24 1023 0 63 24-MAR-02 30 29-SEP-02 90 24-SEP-99 27-DEC-02 25 1024 12 05-NOV-99 26 1025 26 35 31-MAR-00 14-APR-00 27 44 88 31-MAR-02 30-MAY-02 28 1026 1027 1028 95 38 21-JUN-99 17-SEP-99 29 53 88 01-MAY-02 23-JUL-02 30 1029 76 51 14-APR-99 09-JUL-99 Script Output x Query Result x SHIPMENT METHOD ID 1 10 H 2 3 3 4 4 8 5 7 6 7 9 8 7 SOL | Fetched 50 rows in 0.058 seconds ORDER_ID ORDER_DATE CUSTOMER_ID EMPLOYEE_D SHIP_DATE 388 09-OCT-99 400666 6903 13-NOV-02 139 11-JAN-00 802033 4587 14-NOV-02 244 24-JUN-02 401512 1394 15-NOV-02 896 10-MAY-98 401740 8859 13-NOV-02 508 09-FEB-99 201595 2160 15-NOV-02 539 23-JAN-99 401614 3307 17-NOV-02 1272 01-FEB-01 201340 5775 13-NOV-02 1278 29-OCT-01 401572 5648 15-NOV-02 1320 30-NOV-99 901574 8377 14-NOV-02 1334 08-APR-00 401659 5775 16-NOV-02 1459 06-DEC-00 901574 4422 12-NOV-02 1115 05-AUG-98 101484 8762 14-NOV-02 1849 26-OCT-99 101612 9485 14-NOV-02 1874 19-DEC-97 800691 8931 14-NOV-02 1923 27-APR-02 401680 1394 16-NOV-02 1963 15-JUL-98 400666 7741 13-NOV-02 2001 31-DEC-00 201775 9485 15-NOV-02 AN-98 200055 2895 12-NOV-02 7 PAYMENT METHOD ID PAID ORDER STATUS NOTES 4 Y fac"APXA2 YmD) 7 Ph7 (J) 4,2" : @RK36=v!nxCACb, x(u>F2SEJ 4SDGMI := {m 6 N H 19BwI4yNdN99UL] V3!qc -n">V9h5KW_bo_QkZ/ [g13N3wkJ2!-\u16 IN R S>I$3C!tkwufq[iggvKS 7N H --d-6Y1 SZTSC25 E 2 Y (null) 15'B-Mu/Gdarfjpi [-(+xh=H;-28J3>@eg ti) P10VK oed) ) EADP2XB46X 7Y H ZA-PqYzsyp] (X$e"g'g5mYiOHd MlKc9KV_ti\AI2> (Hre, JOGSGXiDDe? 6 Y H U12,7x9, GMHEDIAJ>04.45p-aEkiG+CNcZ228\bq 7Y (null) I]TJPHGGSDY-TIXk_8r=8-/v) (gs\JTaBePR\3=N>*Z2BY]_ukh "MYyP3 4Y H 4;G8;8?L0 [jn -11(y+]nHCzi, uwl. +NR (b8G!i\Yj9XLOPTENEM 2 N G BD> (OSFJ1J/;pud?nc#B0953-00!\H-3:M1170dVET*i@Gy[HA\xQ (P 2N H 0I (aUh"H]H45m30Fiji! SYD28 ENR-ESYBOFEX3Y [K-Z [?rpl]N-V, H101) 3 Y H \dhu 5!um';Ox\7Xz_{vdF'MaN_yq[kodD2aGF2b"+A3#p 4Y H *491 "P$ ]NKI01@2bA! 7R4, ) :: A027SQ :5Vg9th u6FOK6> PRxPaAV)W 9 4 10 6 11 5 12 3 13 4 14 6 15 6 16 7 17 8 18