Question

Write the queries based on the following table
Customer
Code | Item
Price
Oty
101
Shirt
550.00
4
102
Blazer
1800.00
2
103
Track Suit 12500.00
15
104
Shoes
3000.00
3
(a) Write a query to display all records.
(b) Write a query to display the detail of shirt
item.
(c) Write a query to display the detail of those
items whose price is more than 2000.00.
(d) Write a query to display item and price of
those items whose code is 103,​

Answer 1

Answer:

,550.0

1800.00

12500.00.

3000.00

2000.00