Question

Consider the table "item" given below:
Item name
Manufacturer
Pnce
1001
Smart Phone
ABC
20000
1002
Laptop
ABC
55000
1003
Laptop
XYZ
45000
1004
Smart Phone
XYX
15000
1005
Personal Computer
ABC
44000
Write SQL commands to:
a. Display the items manufactured by ABC
b. Display items with price between 20000 and 50000
c. Display all items in the table
d. Display the details of laptop manufactured by ABC.
e Write a command to intsert another row into the table with contents
(1006."Laptop, xyz 50000)
O SELECT DISTINCT Region FROM STATES:
(6) SELECT State FROM STATES ORDER BY State:
(1) SELECT State. Animal FROM STATES WHERE Animal like "S%".
(iv) SELECT State. Region FROM STATES where Districts < 20 OR
Districts > 40
(V) SELECT State. Area from STATES where Area between 100000
and 200000:
sub (I P-CLASS 11)​

Answer 1

Answer:

a. select item name from item where Manufacturer ='ABC';

b. select item name from item where price between 20000 and 50000:

c. select * from item;

d. select * from item where item name = 'laptop' and Manufacturer = 'ABC';

e. insert into item values (1006, ' laptop', 'xyz', 50000);