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 00:00, lilyforeman5867

Match each vocabulary word to its definition.1. desktoppicture used to represent acomputer application2. domainnetwork protectionsoftware code that can be viewed,3. iconmodified, and redistributed for freethe background screen on acomputer monitor4. url5. blogan online journalthe part of an internet address that6. firewallrefers to a group of computers on anetworkonline database of web pages7. intranetnetwork for use by an individual8. open address of a web page or9. wikiresource

Answers: 2

continue

Computers and Technology, 23.06.2019 07:30, barkonatree

What is the penalty for violating section 1201 of title 17 chapter 21 of the us code

Answers: 1

continue

Computers and Technology, 23.06.2019 12:00, daelinrobinson

If you're using an existing powerpoint presentation that will receive new slides based on a word outline, select the a. slide that will appear after the new slides. b. first slide in the presentation. c. slide that will appear before the new slides. d. last slide in the presentation.

Answers: 2

continue

Computers and Technology, 23.06.2019 21:00, webbjalia04

Uget brainliest if accurate mary has been given the responsibility of hiring a person for the position of a software testing officer. which management function would mary achieve this responsibility?

Answers: 1

continue

You know the right answer?

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