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

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 salesman_id 3002 3005 3001 3004 3007 3009 3008 3003 Nick Rimando New York 100 Graham Zusi California 200 Brad Guzan London Fabian Johns Paris Brad Davis New York 200 Geoff Camero Berlin Julian Green London Jozy Altidor Moscow 300 100 200 5001 5002 5005 5006 5001 5003 5002 5007 Salesman Table salesman_id name city commission James Hoog New York 0.15 5001 5002 5005 5006 5003 5007 0.13 0.11 0.14 0.12 0.13 Nail Knite Paris Pit Alex London Mc Lyorn Lauson Hen Paul Adam Rome 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!

sql quickly please 8. Write a SQL query to find the list of customers who appointed a salesman for their jobs who does not live in the same city where their customer lives. Use the tables customer...

Question. Given the structure of inventory database, answer the following: salesman Y SALESMAN_ID NAME CITY COMMISSION NUMERIC (5) VARCHAR 30 ) VARCHAR ( 15 ) DECIMAL(5.2) customer Y CUSTOMER D...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

SQL Assignment SQL, Structure Query Language, is a programming language designed to manage data in relational database systems. It is the language running behind the scenes of a number of database...

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

Consider the tables and write down SQL statements for the questions. 1 . Find the salesperson and customer who reside in the same city. Return Salesman, cust _ name and city. 2 . Find those orders...

Write a SQL statement to show the list of distinct cities the salesmen come from.(3 marks) Write a SQL statement to showthe customer name, city and grade where the grade of a customer is greater than...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Discuss the differences in the auditor's responsibilities for discovering: (1) material errors. (2) material fraud. (3) illegal acts have a direct effect on the financial statements. (4) illegal acts...

We watch two identical astronomical bodies, A and B, each of mass m, fall toward each other from rest because of the gravitational force on each from the other. Their initial center-to-center...

In debt financing, the interest that a company pays to its bondholders is tax deductible. a . True b . False

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

3. Trainees are comfortable using technology, including the Web, personal computers, and CD-ROMs.

4. The increased use of new technology is part of the companys business strategy. New technology is being used or implemented in manufacturing of products or service processes.

1. Sufficient budget and resources will be provided to develop and support the use of new technology.