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
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 Salesman salesman_id name city commission 5001 5002 5005 5006 5003 5007 James Hoog New York 0.15 Nail Knite Paris Pit Alex London Mc Lyon Lauson Hen Paul Adam Rome 0.13 0.11 0.14 0.12 0.13 Paris Customer customer_id cust_name city grade salesman_id 3002 Nick Rimando New York 100 5001 3005 Graham Zusi California 200 5002 3001 Brad Guzan London 3004 Fabian Johns Paris 300 5006 3007 Brad Davis New York 200 5001 3009 Geoff Camero Berlin 100 5003 3008 Julian Green London 300 5002 5005
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
