Computers and Technology, 27.03.2021 09:00 kaylonjohnwell23

Q18. Write the SQL command for the following on the basis of given table. Table : FURNITURE
PRICE
NO ITEMNAME TYPE DATEOFSTOCK
DISCOUNT
(%)
23/02/2002
30000
Bouble bed
1
25
White lotus
20/01/2003
20
Pink feather
7000
2
Baby cot
Baby cot
3
Dolphin
20
19/02/2003
9500
Decent
Office Table
01/01/2002
25000
30
Comfort zone
5
Double bed
12/01/2002
25000
25
Donald
6
Baby cot
24/02/2002
6500
15
i. To display itemnames bought in the year 2003.
ii. To increase the discount by 5% for items where price is in the range of 5000
and 10000
To delete all those records where the itemname starts with D and ends with n.
iv. Add a field by the name quan_in_hand to store the number of items for every item.
v. Select min(dateofstock) from furniture;
vi. Select sum(price) from furniture where discount IN ( 20,30);

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 18:00

Ramona enjoys her job because she is able to kids in an after school program. the work value ramona feels strongest about is a. leadership b. risk c. independence d. work with people select the best answer from the choices provided a b c d

Answers: 1

Answer

Computers and Technology, 24.06.2019 22:10

How many different ways are there to order the eight jobs in the queue so that job usu comes somewhere before cdp in the queue (although not necessarily immediately before) and cdp comes somewhere before bbd (again, not necessarily immediately before)?

Answers: 1

Answer

Computers and Technology, 25.06.2019 08:10

Is a philosophy and a software and system development methodology that focuses on the development, use, and reuse of small, self-contained blocks of codes to meet the software needs of an organization.joint application designextreme programmingrapid application developmentservice-oriented architecture

Answers: 1

Answer

Computers and Technology, 25.06.2019 17:40

4) wilkes continues to discuss the concept of time and how it relates to the type of photography he does. why do you feel that the concept of time is of suck importance to him as a photographer? 5) unit 10 explores photographs with movement in them such as wildlife and documentary photography. wilkes takes the idea of movement in photography to a different level. do you feel the tips and information that you have learned in unit 10 is applicable to the type of photography that wilkes does? answer as soon as possible im so confused

Answers: 1

Answer

You know the right answer?

Q18. Write the SQL command for the following on the basis of given table. Table : FURNITURE
PR...

Questions