Question

Table: CAR

Write queries to

i) Display all the details from the table ‘CAR’ those type is Petrol.

ii) Display the details of car whose price is less than 6.9lac.

Car_no Car_name Company Type Price

WB 01 A007 Hyundai i20 2020 Hyundai Petrol 4.5lac

KL 01 K019 Kia Sonet Kia Motors diesel 6.5lac

DL 01 M013 Kia Sonet Kia Motors diesel 6.8lac

WB 01 A078 Nissan Magnite Nissan Motor Petrol 7.8lac

BR 01 X045 Tata Altroz Tata diesel 6.9lac​

Answer 1

Answer:

hi,

Explanation:

1) Display all the details from the table ‘CAR’ those type is Petrol.

select * from car where type like "petrol";

___________________________

2)Display the details of car whose price is less than 6.9lac.

select * from car where price <6.9lac;

___________________________

:)