Scribd
Upload
14 views8 pages

Computer Homework of SQL 25queries

The document outlines a project on SQL involving the creation and management of a database named 'Car Details'. It includes various tasks such as designing tables, inserting records, and displaying specific car details based on different criteria. The project covers a range of SQL queries to manipulate and retrieve data related to cars.

Uploaded by

sangeetapatil9227
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
14 views8 pages

Computer Homework of SQL 25queries

The document outlines a project on SQL involving the creation and management of a database named 'Car Details'. It includes various tasks such as designing tables, inserting records, and displaying specific car details based on different criteria. The project covers a range of SQL queries to manipulate and retrieve data related to cars.

Uploaded by

sangeetapatil9227
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

PROJECT

ON MY
SQL
By PARTH PATIL

Q1. Create a database name Car Details:


Q2. Design a Table with given attributes:

Q3. Insert 20 records in car table:


Q4. Display the details of CNG cars whose mileage is more than 25km/l:

Q5. Display the details of Black color SUVs:

Q6. Display the details of the car whose purchase year is 2023 and name starting
from ‘S’:

Q7. Display the details of Harrier whose price ranges b/w 15 to 30 lakhs:

Q8. Display the details of BMW cars whose fuel type is DIESEL and price ranges
between 50-70 lakhs:

Q9. Display the details of the car(s) whose name has ‘TR’ substring in their name:
Q10. Display the details of the car whose company name starts with ‘M’ fuel type
‘PETROL’ and car type ‘SUV’:

Q11. Display the details of car which gives maximum mileage: (electric)

Q12. Display the details of Sports cars which are either Red or Orange in color:

Q13. Display the details of car company wise in descending order:


Q15. Display the total price of cars company wise:

Q16. Display the details of car purchased between year 2020-23 whose price is
between 10-20 lakhs:

Q17. Display the details of cars whose fuel capacity is more than 50 liters :
Q18. Display the details of car whose number plate starts with ‘MH-12’:

Q19. Display the details of diesel SUV’s whose mileage is between 40-50 lit:

Q20. Display the details of CNG cars whose no. plate has ‘245’:

Q21. Display the details of Toyota and Nissan Company car ranging b/w 50 lakhs
to 1 Cr:
Q22. Display the details of car whose name has ‘or’ substring in it purchased in
year 2024:

Q23. Display the count of cars company wise:

Q24. Display the average price of cars whose company name starts with ‘M’ or ‘H’:

Q25. Delete the records of cars whose price is more than 1 CR:

---------------------THANK YOU------------------------

You might also like