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

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 commission he gets for an order. Sample table: orders ord_no purch_amt ord_date customer id salesman_id 70001 70009 70002 70004 70007 70005 70008 70010 70003 70012 70011 70013 150.5 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 2012-10-10 3004 2012-10-10 3009 2012-06-27 3008 2012-08-17 3003 2012-04-25 3002 5002 5005 65.26 110.5 948.5 2400.6 5760 1983.43 2480.4 250.45 75.29 3045.6 5001 5003 5002 5001 5001 5006 5003 5002 5007 5001 Salesman city commissior salesman id name James Hoog New York 0.15 5002 5005 5006 5003 5007 Nail Knite Paris Pit Alex London Mc Lyon Lauson Hen Paul Adam Rome 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!

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

[Marks 10] Question 4: Queries Using SQL Write following SQL Queries: 1. 2. List the order number, order date, customer number, customer name (first and last), employee number, and employee name...

Cape Codd Database Table Structure: (Tables & Fields) Catalog_SKU_2016 Catalog_SKU_2017 CatalogID (PK, int, not null) SKU (int, not null) SKU_Description (char(35), not null) Department (char(30),...

6. Write an SQL statement to add a column floor to the room table. You should put your answers to these questions. staffID name 12345 James 54321 Gaga 09876 Super Page 3 (2 marks) Practices: I. (1...

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

--============================================ /* 1. Write a SQL statement that uses a sub_query. The sub-query should find the employee_ids of managers. The outer query should list all employee...

The last two images are to show the extra files I was given to assist with this project. The QuattroGameTester.java looks like this, added this just so you know. Thanks! Background You are working in...

a)write a query in SQL to create employees table using table-1 b) write a query in SQL to find highest salary employees c)write a query in SQL to find highest salary for female employees d) write a...

Download the database from the following link if you don't have it already on your local system. http://mysql-tools.com/en/downloads/mysql-databases/4-sakila-db.html Write a SQL statement that...

Pass the popcorn: Following are the running times (in minutes) for the 12 top-grossing movies rated PG or PG-13, and the 12 top-grossing movies rated R, for the recent weekend. Movies rated PG or...

Q: A categorical variable has three categories with the following frequencies of occurrence: a. Compute the percentage of values in each category. b. Construct a bar chart. X c. Construct a pie...

True or false: Because deferred tax assets and liabilities never reverse, we almost never see a deferred tax asset or liability balance of zero in a balance sheet. True false question. True False

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Employee participation in organizational decision making was, as McGregor reports, viewed with skepticism at the time he was writing. Is it now more widely valued and utilized? If so, why? If not,...

Research unambiguously finds that more participative gainsharing programs outperform simple incentive schemes that lack a participative component. Why is it, then, that so many gainsharing...

McGregor was drawn to the way Scanlon plans minimize internal competition in an organization, while maximizing external competition. Is this approach still valid today?