Computer Science, asked by tonydhaka123, 8 months ago

34. Consider the following table FITNESS with detail about fitness products being sold in
the store. Write command of SQL for (i) to (ii)
PCODE
PNAME
PRICE
MANUFACTURER
P1
Treadmill
21000
Coscore
P2
Bike
20000
Aone
P3
Cross Trainer
14000
Reliable
P4
Multigym
34000
Coscore
P5
Massage Chair
5500
Regrosene
P6
Belly Vibrator Belt
6500
Ambawya
(a) to display the names of all the products with price more than 20000.
(b) to display the names of all products by the manufacturer “Aone".
(c) to change the price data of all the products by applying 25% discount reduction.
web.whatsapp.c

Answers

Answered by bhanuteja8

1

Answer:

type properly what happened to all no one are typing properly

Answered by maheekanage

4

Answer:

here's your answer friend

Attachments:

Previous Question

Next Question

Similar questions

Biology, 3 months ago

Describe the structure of a Human Brain.

Math, 3 months ago

the common factor of 3a²b⁴c², 12b²c⁴and 15a³b⁴c⁴is...

Computer Science, 3 months ago

_______is defined as the number of digits in the number system.

English, 8 months ago

what is meant by assertive, imperative and interogative sentence. please answer as soon as possible and also give an example for it.

Math, 8 months ago

1 A kilogram of dalandan in Pure Gold costs P55.00. If Jessica bought k kilograms, represent the amount paid A as a function...

Math, 1 year ago

if a + b is equal to 7 and a b is equal to 12 find the value of a square minus ab + b square...

Physics, 1 year ago

What is the frequency of the hand on a clock that measures the second s...

Math, 1 year ago

value of tan 0 = 3/5 . Find the value of sec 0...