Question

Study the following table(s)
COURIER
CNO
Coule
CName
Vicky
Sam
01-Jan-2018
11-Feb-2019
30-Apr-2018
|
2
重 Louis
Terry
200
Rosy
01-Aug-2019
13-NON-2119
21-Jul-2019
17-May-2DIS
15-Jan-2019
Elizabeth
Nicolas
U
3.
1
DESTINATION
Duode
1
2
3
1. Display cname, odate and amount of all the couriers in decreasing ander or amount.
2. Display cno, amount from the table courier having otale between OL-apr-2018 and
01-jun-2018
3. Display cname and their corresponding destination city.
4. Display the total amount of orders for each city code:
5. Increase the amount by 10% for coode=4​

Answer 1

Answer:

bihubjbjbihuvybihyvtcihtibuh