Database schema and SQL Queries for Car Manufacturers and sellers

🚗 SQL Queries for Car Manufacturer & Seller Database

Learn how to query a car marketplace database using practical SQL examples covering manufacturers, models, sellers, and listings.

🔍 Basic Queries

1. Get All Manufacturers

SELECT * FROM Manufacturer;

2. Get Car Models with Manufacturer Names

SELECT CarModel.*, Manufacturer.Name AS ManufacturerName FROM CarModel JOIN Manufacturer ON CarModel.ManufacturerID = Manufacturer.ManufacturerID;

3. Get All Seller Companies

SELECT * FROM SellerCompany;

🚘 Advanced Queries

4. Complete Car Listings (Model + Seller)

SELECT CarListing.*, CarModel.Name AS ModelName, SellerCompany.Name AS SellerName FROM CarListing JOIN CarModel ON CarListing.CarModelID = CarModel.ModelID JOIN SellerCompany ON CarListing.SellerID = SellerCompany.SellerID;

5. Find Models by Manufacturer (Toyota)

SELECT CarModel.* FROM CarModel JOIN Manufacturer ON CarModel.ManufacturerID = Manufacturer.ManufacturerID WHERE Manufacturer.Name = 'Toyota';

6. Find Used Car Listings

SELECT CarListing.*, CarModel.Name AS ModelName, SellerCompany.Name AS SellerName FROM CarListing JOIN CarModel ON CarListing.CarModelID = CarModel.ModelID JOIN SellerCompany ON CarListing.SellerID = SellerCompany.SellerID WHERE CarListing.Condition = 'Used';

📈 Analytical Queries

7. Average Price of Cars

SELECT AVG(Price) AS AveragePrice FROM CarListing;

8. Latest Car Model by Manufacturer (BMW)

SELECT CarModel.* FROM CarModel JOIN Manufacturer ON CarModel.ManufacturerID = Manufacturer.ManufacturerID WHERE Manufacturer.Name = 'BMW' ORDER BY Year DESC LIMIT 1;

📚 Want full schema details?
Read Complete Schema Explanation

💡 Pro Tip: You can generate sample datasets, SQL queries, and more tools on Docynx.