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, 22.06.2019 12:30

Which of the choices sean are not true when considering virus behavior

Answers: 1

Answer

Computers and Technology, 23.06.2019 22:30

Janice usually works on a particular workbook that contains all business related data. she decides to keep a backup of all the data in a separate workbook. she opens a new workbook to transfer the data. which option should she use to copy all the data from one workbook to another workbook?

Answers: 1

Answer

Computers and Technology, 24.06.2019 00:00

For the following example of making a peanut butter and jelly sandwich, identify which are inputs, processes, or outputs: bread scooping and spreading peanut butter plate scooping and spreading jelly finished sandwich putting two pieces of covered bread together dirty plate crumbs

Answers: 2

Answer

Computers and Technology, 24.06.2019 14:00

Text or graphics that print at the bottom of every page are called footings footers headers headings

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