Scribd
Upload
109 views11 pages

Cities For The Salesmen and Customer Who Belongs To The Same City

The document contains a series of SQL questions and corresponding solutions related to salesmen, customers, and orders. Each question focuses on specific data retrieval tasks, such as listing salesmen and customers from the same city, filtering orders by amount, and identifying salesmen associated with customers. The document serves as a guide for writing SQL statements to extract relevant information from a database.

Uploaded by

M.Faizan Usman
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
109 views11 pages

Cities For The Salesmen and Customer Who Belongs To The Same City

The document contains a series of SQL questions and corresponding solutions related to salesmen, customers, and orders. Each question focuses on specific data retrieval tasks, such as listing salesmen and customers from the same city, filtering orders by amount, and identifying salesmen associated with customers. The document serves as a guide for writing SQL statements to extract relevant information from a database.

Uploaded by

M.Faizan Usman
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
You are on page 1/ 11

Question 1: Write a SQL statement to prepare a list with salesman name, customer name and their

cities for the salesmen and customer who belongs to the same city.

SOLUTION
Question 2: Write a SQL statement to make a list with order no, purchase amount, customer name
and their cities for those orders which order amount between 500 and 2000.

SOLUTION
Question 3: Write a SQL statement to know which salesman are working for which customer.

SOLUTION
Question 4: Write a SQL statement to find the list of customers who appointed a salesman for their
jobs who gets a commission from the company is more than 12%.

SOLUTION
Question 5: Write a SQL statement to make a list for the salesmen who works either for one or more
customer or not yet join under any of the customers who placed either one or more orders or no order
to their supplier.
SOLUTION

You might also like