SOI.

Qn $4.$ Write the following SQL statements using CLIENT and ORDER tables:

CLIENT

ORDER

Questions:

a$.$ Display client details in descending order of the client's first name and then by the last

name in ascending order.$|$

b$.$ Find details of all clients whose last name begins with $\text{'}S\text{'}.$ 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

Display results in descending order of GrdedD,