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

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 11:30, genyjoannerubiera

What does a cascading style sheet resolve a conflict over rules for an element? a. the rule affecting the most content wins b. the rule affecting the most content loses c. the rule with the most specific selector loses d. the rule with the most specific selector wins

Answers: 2

continue

Computers and Technology, 23.06.2019 09:30, kreshnikolloma

You wanted to look up information about alzheimer's, but you were unsure if it was spelled "alsheimer's" or "alzheimer's." which advanced search strategy would be useful? a) a boolean search b) using a wild card in your search c) trying different search engines d) doing a search for "alsheimer's not alzheimer's" asap. ill give brainlist.

Answers: 1

continue

Computers and Technology, 24.06.2019 17:50, jones03riley

You work in the accounting department and have been using a network drive to post excel workbook files to your file server as you complete them. when you attempt to save a workbook file to the drive, you see the error message: “you do not have access to the folder ‘j: \’. see your administrator for access to this folder.” what should you do first

Answers: 2

continue

Computers and Technology, 24.06.2019 20:30, LaughingAlanna

Does the query hawaiian photographers fully meets results?

Answers: 1

continue

Do you know the correct answer?

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