Cognizant Handson - Car details based on type and name

 

Car details based on type and name

Write a query to display car id, car name and car type of Maruthi company 'Sedan' type cars.  Sort the result based on car id.

(HINT : Use Cars table to retrieve records.car name='Maruthi Swift'.car type='Sedan'.Data is case sensitive.)

NOTE: Maintain the same sequence of column order, as specified in the question description

Solution:

select car_id,car_name,car_type from cars where car_type='Sedan' and car_name like 'Maruthi%';