Given the three tables below, write the followingqueries.
Customer
custNo
custName
custSt
custCity
age
1
C1
Olaya St
Jeddah
20
2
C2
Mains St
Riyadh
30
3
C3
Mains Rd
Riyadh
25
4
C4
Mains Rd
Dammam
5
C5
Mains Rd
Riyadh
Product
prodNo
prodName
prodDes
price
100
P0
Food
100
101
P1
healthy Food
100
102
P2
200
103
P3
self_raising flour,80%wheat
300
104
P4
network 80x
300
Order
ordNo
ordDate
custNo
prodNo
quantity
R03010101
01-jan-2003
C01
100
2
R03010203
02-jan-2003
C01
101
1
R03010102
01-jan-2003
C2
102
1
R03010103
01-jan-2003
C343
100
2
R03010301
03-jan-2003
C01
101
1
R03030601
06-mar-2003
C2
100
10
A DDL command to build order table, including allintegrity constraints. Make sure that ordDate value exists andquantity value is always positive.
[0.5 marks]
Ans:
A DML command to answer: How many orders were made bycustomer C01 and how many products pieces did heorder?
Ans:
A DML command to list customers who have ordered theproduct 100. (Hint: use join)
Ans:
A DML command to find products with price more thanaverage (Hint: use nested
PayPal Gateway not configured
PayPal Gateway not configured