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

  1. Write a SQL statement to show the list of distinct cities the salesmen come from. (3 marks)
  2. Write a SQL statement to show the customer name, city and grade where the grade of a customer is greater than 100 (3 marks)
  3. Write a SQL statement to show city name and the number of customers from each city (3 marks)
  4. Write a SQL statement to show the salesman and the customers served by that salesman. (3 marks)
  5. Write a SQL statement to show the customer name, city name of a customer, salesman name and commission where a salesman gets more than 0.12 commission from the company. (3 marks)

F. Write a SQL statement to show the maximum grade of a customer where the city of customer is in London. (3 marks)


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!

Q:

WHAT something significant that you learned about Crisis Management in the article below. https://torontosun.com/2014/10/26/man-dies-after-double-stabbing-at-canadas-wonderland

Q:

1. Write n SQL statement to list all cities and states of vendor addresses. Make sure the result does not include duplicates. 2. Write n SQL statement to list the item ID, item description and item...

Q:

Safari File Edit View History Bookmarks Window Help W. h Question Completion Status: elearning.miami.edu La AA 89% [4] Sun 1:34 PM lil G + 2 matches Q Using the step-dow Done 2 3 5 8 90 100 11 12 13...

Q:

Question. Given the structure of inventory database, answer the following: (9*0.5 + 2*0.25 = 5 points) Salesman SALLEMAND NUMERIC (5) VARCHAR(30) WAR (15 DECIMALES CITY customer CUSTOMER O NUMERIC...

Q:

Dataset (`handy-bonbon-142723.order_entry_dataset`) available on Google BigQuery. 1) Write a SQL statement to show the total dollar amount sold to customers summarized by state/province of their...

Q:

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

Q:

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

Q:

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Q:

Write SQL statements to list all columns for all tables. Write an SQL statement to list ItemNumber and ItemDescription for all items that cost more than $100. Write an SQL statement to list...

Q:

Flow control mechanisms in networks can be loosely categorised as open loop, and closed loop. (i) Describe the closed loop feedback control scheme employed by the Transmission Control Protocol (TCP)...

Q:

in 100 to 200 words, post your takeaway on "Strategy and Tactic for Distributive Bargaining"

Q:

Exhibit 6-10 Midwest Office Products: Five Orders ORDER Price Acquisition cost 1 2 3 4 5 $610 $634 $6,100 Number of cartons in order $6,340 $6,100 500 500 5,000 5,000 5,000 Manual order Number of...

Q:

Use the moment Distribution Method to determine the bending moments at supports A, B and C for the continuous beam loaded as shown below. The beam has a constant cross- section. w=2k/ft 178 A 8' P=6K...

Q:

Argo Manufacturing Co. had 500 units, three-fifths completed, in process at the beginning of the month. During the month, 2,000 units were started in process and finished. There was no work in...

Q:

Experts felt that one of the biggest challenges faced by MTV while launching MTV Arabia was the prevalent culture in the Arab world. Discuss the Arab culture. What challenges does the culture pose to...

Q:

Chelsea Truman sells celebrity magazines on Sunday morning in an area surrounded by three busy shopping centers. Demand for the magazines is distributed as shown in the following table: Chelsea has...

Q:

Bill has just returned from a duck hunting trip. He has brought home eight ducks. Bills friend, John, disapproves of duck hunting, and to discourage Bill from further hunting, John has presented him...

Q:

Why do auditors consider inventory errors pervasive?

Q:

Which type of marketing research is undertaken to gather background information and data that may be helpful in defining the problem? Prescriptive Informal Diagnostic Descriptive Exploratory

Q:

Using your knowledge of the college environment, identify three transactions that might be handled by online transaction processing (OLTP) systems.

Q:

When do you use a make-table query?

Q:

What additional factors must you consider during the information-level design of a distributed database?

Q:

Hughie, Dewey, and Louie are equal shareholders in HDL, an S corporation. HDL's S election terminates under each of the following alternative scenarios. When is the earliest it can again operate as...

Q:

Birch Corp., a calendar-year corporation, was formed three years ago by its sole shareholder, James, who has operated it as an S corporation since its inception. Last year, James made a direct loan...

Q:

In year 2, Julio and Milani received distributions of $20,000 and $30,000, respectively, from Falcons Corporation. a. What amount of ordinary income and separately stated items are allocated to them...