Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Write a SQL statement to know which salesman are working for which customer. Customer table customer_id cust_name city grade salesman_id 3002 Nick Rimando New

image text in transcribed
3. Write a SQL statement to know which salesman are working for which customer. Customer table 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 3004Fabian Johns Paris 300 5006 3007 Brad Davis New York 200 5001 3009 Geoff Camero Berlin 100 5003 3008 Julian Green London 300 5002 5005 Salesman table salesman_id name city commission 5001 5002 5005 5006 5003 5007 James Hoog New York Nail Knite Paris Pit Alex London Mc Lyon Lauson Hen Paul Adam Rome 0.15 0.13 0.11 0.14 0.12 0.13 Paris

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

To find integral of sin(logx) .

Answered: 1 week ago

Question

What is Centrifugation?

Answered: 1 week ago

Question

To find integral of ?a 2 - x 2

Answered: 1 week ago

Question

To find integral of e 3x sin4x

Answered: 1 week ago