Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Refer to the tables below and 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. Table: Salesman...

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%. Customer table customer_id cust_name city grade...

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...

Answer all the following questions: Explain the meaning of data Model? Differentiate between the types of data model? Differentiate some of the advantages and disadvantages of file processing...

Use the tables given below to answer the following questions (a) - (1) Customers table cust_id cust_name 3001 Nick Rimando 3002 Brad Davis cust id city New York New York California 3003 Graham Zusi...

Q: Write the queries that result in the following scenarios and display their outputs. Q1) Type the query that displays the cities -without repetition of all orders. Q2) Type the query that displays...

6. Write a SQL statement to find the details of a order i.e. order number, order date, amount of order, which customer gives the order and which salesman works for that customer and how much...

assignment in database lab course Grade 100 200 Customer X Customer_ID. Customer_Name 3001 Nick Rimando 3002 Graham Zusi 3003 Brad Guzan 3004 Fabian Johns 3005 Brad Davis 3006 Geoff Camero 3007...

L statement to make a list in ascending order for the customer who works either write a SQOL to through a salesman or by o wn. Sample table: customer er id cust_name customer_id salesman_id city...

Wrne column of each table will appear once and only the relational rows will come. L statement to make a join on the tables salesman, customer and orders in such a form that Sample table: orders...

Using capture programs such as Wireshark and built-in programs like ping, nslookup, and ipconfig, find and capture screen shots showing the following information: a. Your computer's MAC address...

Repeat Exercise 8.40, but with n = 30 observations in each sample. Repeat Exercise Using the procedures in Computer Solutions 8.1 as a general guide, simulate 150 simple random samples of size n = 4...

What is the correct way to calculate dura on for a putable bond? a . Macaulay dura on b . Modified dura on c . Approximate modified dura on d . Effec ve dura on

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+1 Are WLB issues different in newly developing countries from what is experienced in developed countries? Why or why not? Is there a trade-off between WLB and career ambition?

=+2 What is an employers duty in preparing its employees for foreign assignments?

=+2 Why have family-friendly and work-life balance programs become so important?