Write a SQL statement to show the list of distinct cities the salesmen come from.(3 marks) Write
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write a SQL statement to show the list of distinct cities the salesmen come from. (3 marks)
- Write a SQL statement to show the customer name, city and grade where the grade of a customer is greater than 100 (3 marks)
- Write a SQL statement to show city name and the number of customers from each city (3 marks)
- Write a SQL statement to show the salesman and the customers served by that salesman. (3 marks)
- Write a SQL statement to show the customer name, city name of a customer, salesman name and commission where a salesman gets more than 0.12 commission from the company. (3 marks)
F. Write a SQL statement to show the maximum grade of a customer where the city of customer is in London. (3 marks)
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: