Q8. Write the SQL command for (i) to (vi) &
output for (vii) on basis of Table: PRODUCTS
given below. 1/2*8=4
PRODUCTS TABLE
22
PCODE PNAME COMPANY PRICE STOCK MANUFACTURE WARRANTY
10000 200
12-JAN-2018
P002 TV
SONY
12000
23-MAR-2017
P003
LENOVO
39000
09 APR-2018
P004
COMPAQ 38000
20-JUN-2019
PO05 HANDYCAM SONY
18000 250 23-MAR-2017
OF To show details of all PCs with stock more than 110
ii) To list the company which gives warranty of more than 2 years.
(iii) To find stock value of the BPL company where stock value is sum of the products of price and stod
(iv) To show number of products from each company.
(v) To count the number of PRODUCTS which shall be out of warranty on 20-NOV-2020.
(vi) To show the PRODUCT name of the products which are within warranty as on date.
(vii) Give the output of following statements:
(a) Select COUNT(distinct company) from PRODUCT
(b) Select MAX{price)from PRODUCT where WARRANTY<=3
Your answer
Answers
Answered by
0
Answer:
little confusing
Explanation:
Similar questions