Students need to Upload all evidence in one pdf document containing Screenshots of each step taken in accordance to the assessment.
Table: Salesman
salesman_id | name | city | commission -------------+------------+----------+------------ 5001 | James Hoog | New York | 0.15 5002 | Nail Knite | Paris | 0.13 5005 | Pit Alex | London | 0.11 5006 | Mc Lyon | Paris | 0.14 5007 | Paul Adam | Rome | 0.13 5003 | Lauson Hen | San Jose | 0.12
Table
: Customer
customer_id | cust_name | city | grade | salesman_id -------------+----------------+------------+-------+------------- 3002 | Nick Rimando | New York | 100 | 5001 3007 | Brad Davis | New York | 200 | 5001 3005 | Graham Zusi | California | 200 | 5002 3008 | Julian Green | London | 300 | 5002 3004 | Fabian Johnson | Paris | 300 | 5006 3009 | Geoff Cameron | Berlin | 100 | 5003 3003 | Jozy Altidor | Moscow | 200 | 5007 3001 | Brad Guzan | London | | 5005
- Create
SQL statement (JOIN)
to display a list with salesman name, customer name and their cities for the salesmen and customer who belongs to the same city. (
Use the JOIN statement
))
- Create a
function
that calculate the total commission
-Create a
store procedure
that displays the names of salesman located in Paris and their commission
Extracted text: students need to Upload all evidence in one pdf document containing Screenshots of each step taken in accordance to the assessment. Table: Salesman salesman_id | city | commission name 5e01 | James Hoog | New York | 5ee2| Nail Knite | Paris 5ee5 Pit Alex see6 | MC Lyon 5007 | Paul Adam | Rome 5e03 | Lauson Hen | San Jose | 0.15 0.13 | London | Paris 0.11 0.14 0.13 0.12 Table: Customer
Extracted 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