Qn $4.$ Write the following SQL statements using CLIENT and ORDER tables:CLIENTClientIdLastNameFirstNameSuburbPhoneCity$1$JasonRitaBella Boulevard$3432422$Sydney$2$SmithJacksonHigh Park$5535333$Sydney$3$WagnerJamesRichmond$4425253$Perth$4$BlakeSusanRockdale$5141412$Brisbane$5$JonesTaniaComo$5474574$Melbourne$6$LynnKarinaDural$1231241$Sydney$7$WaltersMaxHigh Park$4574774$Perth$8$PoplarLiamCrasspark$1312425$Brisbane$9$RobbNoahElwood$6746236$Melbourne$10$HenlonJamesHawthrone$1235636$DarwinORDEROrderNoOrderDescClientIdOrderDateShippedDateCountryTotal Amount$17895$Large Item$312/10/1816/10/18$Australia$200\mathrm{.}5021678$Small Item$205/01/1909/01/19$Italy$300\mathrm{.}0022456$Item ABC$410/03/1912/03/19$France$400\mathrm{.}7524562$Medium Item$226/12/1927/12/19$Australia$150\mathrm{.}00347643$ Tier Design$518/07/2020/07/20$Japan$370\mathrm{.}6036533$Round Box$822/09/2027/09/20$Australia$190\mathrm{.}8536536$Brand$-005322/09/2024/09/20$China$216\mathrm{.}7537454$Express Delivery$111/11/2014/11/20$Denmark$625\mathrm{.}00$ Questions:a$.$ Display client details in descending order of the clients first name and then by the last name in ascending order.b$.$ Find details of all clients whose last name begins with S$.$ Display results in descending order of city. c$.$ Display the number of clients living in Sydney. d$.$ Display order ID$,$ client details $($name$,$ ID of clients$),$ and country for the orders placed in $2020.$ Display results in descending order of OrderID.