Scribd
Upload
9 views1 page

SQL Queries for Car Showroom Analysis

The document contains a series of SQL queries related to a Car Showroom Database. It includes requests for average sale prices, customer house numbers, payment details, employee salaries, invoice numbers, and employee join dates. Each query targets specific data points to extract meaningful insights from the database.

Uploaded by

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

SQL Queries for Car Showroom Analysis

The document contains a series of SQL queries related to a Car Showroom Database. It includes requests for average sale prices, customer house numbers, payment details, employee salaries, invoice numbers, and employee join dates. Each query targets specific data points to extract meaningful insights from the database.

Uploaded by

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

My SQL extra questions:

Car Showroom DataBase

1. Display the Average saleprice rounded off to 1 decimal place of those cars for which
the sale is after the year 2018.
2. Display only the house no. of each customer. (Don't include ,)
3. Display the payment made and maximum sale done through that payment mode.
4. Display the total payment done by each customer.
5. Display the minimum salary for each designation of employees where minimum
salary should be 26000.
6. List the invoice No. with year of Sale of Date in descending order of year from the
table Sale.
7. Display the employees who are born in August and joined in the month January.
8. List the total no. of employees who have joined in the months January & July.

You might also like