Create a function that calculate the total commission

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Create a function that calculate the total commission

customer_id |
cust_name
city
I grade | salesman_id
3002 | Nick Rimando
3007 | Brad Davis
3005 | Graham Zusi
3008 | Julian Green
3004 | Fabian Johnson | Paris
3009 | Geoff Cameron | Berlin
3003 | Jozy Altidor
3001 | Brad Guzan
100 |
200|
| New York
|New York
| california |
| London
5001
5001
200 |
5002
300
5002
300 |
5006
100 |
5003
|Moscow
| London
200
5007
5005
Transcribed Image Text:customer_id | cust_name city I grade | salesman_id 3002 | Nick Rimando 3007 | Brad Davis 3005 | Graham Zusi 3008 | Julian Green 3004 | Fabian Johnson | Paris 3009 | Geoff Cameron | Berlin 3003 | Jozy Altidor 3001 | Brad Guzan 100 | 200| | New York |New York | california | | London 5001 5001 200 | 5002 300 5002 300 | 5006 100 | 5003 |Moscow | London 200 5007 5005
salesman_id |
name
city
| commission
5e01 | James Hoog | New York |
5ee2| Nail Knite | Paris
5ee5 Pit Alex
5ee6 MC Lyon
5e07 | Paul Adam | Rome
5ee3 Lauson Hen San Jose
0.15
0.13
| London
| Paris
0.11
0.14
0.13
0.12
Table: Customer
Transcribed Image Text:salesman_id | name city | commission 5e01 | James Hoog | New York | 5ee2| Nail Knite | Paris 5ee5 Pit Alex 5ee6 MC Lyon 5e07 | Paul Adam | Rome 5ee3 Lauson Hen San Jose 0.15 0.13 | London | Paris 0.11 0.14 0.13 0.12 Table: Customer
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY