Question

22
[4]
Orders(in Rs) Payments(in R
Orderno
Orderdate
CName
Cloc
1
2.
3
12/02/2008
21/11/2008
15/10/2008
13/1/2008
17/7/2008
16/6/2008
Avlon
Parason
Trident
Avlon
Trident
Nalco
Delhi 100000
Jaipur 230000
Raipur 120000
Jaipur 240000
Delhi 340000
Chennai 140000
90000
230000
100000
240000
310000
140000
4
5
7.
1.
2.
3.
List Companies listed in the table Ans select distinct came from order.
Insert a column Discount_percent type int (4)
Add values under Discount percent column such that 10% discount is given to those
companies who have made full payments.
Find number of companies and average orders given to then city wise.
List all orders given between 1/1/2008 to 12/10/2008.
4.
5.​

Answer 1

Companies listed in the table Ans select distinct came from order.

Insert a column Discount_percent type int (4)

Add values under Discount percent column such that 10% discount is given to those

companies who have made full payments.

Find number of companies and average orders given to then city wise.

List all orders given between 1/1/2008 to 12/10/2008.

4.

5.

Answer 2

Answer:

sector is perfect but equation is not matching

Explanation:

please like