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.

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter10: Application Development
Section: Chapter Questions
Problem 9VE
icon
Related questions
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.
customer_id
3002
3007
3005
3008
cust_name
Nick Rimando
Brad Davis
Graham Zusi
Julian Green
city
New York
New York
California
London
grade
100
200
200
300
salesman_id
5001
5001
5002
5002
Transcribed Image Text:customer_id 3002 3007 3005 3008 cust_name Nick Rimando Brad Davis Graham Zusi Julian Green city New York New York California London grade 100 200 200 300 salesman_id 5001 5001 5002 5002
salesman_id name
5001
5002
5005
5006
5007
5003
Ahmed
Ali
Kamel
Seko
Ruzaima
Putri
city
Amman
Cairo
Algeria
Nigeria
Kuala
lumpur
Shah alam
commission
0.15
0.13
0.11
0.14
0.13
0.12
Transcribed Image Text:salesman_id name 5001 5002 5005 5006 5007 5003 Ahmed Ali Kamel Seko Ruzaima Putri city Amman Cairo Algeria Nigeria Kuala lumpur Shah alam commission 0.15 0.13 0.11 0.14 0.13 0.12
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning