Show each agents name, the sum of the contract price for the engagements booked, and the agents
Fantastic news! We've Found the answer you've been seeking!
Question:
Show each agent’s name, the sum of the contract price for the engagements booked, and the agent’s total commission for agents whose total commission is more than $700
Transcribed Image Text:
Entertainment Agency Example Database CUSTOMERS .......... HH CustomerlD CustFirstName CustLastName CustStreetAddress PK HH CustCity CustState CustZipCode CustPhoneNumber MUSICAL PREFERENCES ✰✰✰✰✰✰✰✰✰✰... CustomerID StylelD PreferenceSeq StylelD StyleName ...…...... CPK CPK MUSICAL_STYLES ......... ...... ....... PK HE ENGAGEMENTS EngagementNumber PK StartDate EndDate StartTime Stop Time ContractPrice Customer D AgentID EntertainerID ENTERTAINERS FK FK FK EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEmailAddress DateEntered EntertainerID StylelD StyleStrength PK H ENTERTAINER_STYLES ...….….. CPK CPK Does not include Chapter 20 "driver" tables AGENTS AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhone Number DateHired Salary Commission Rate PK ENTERTAINER_MEMBERS EntertainerID MemberID Status MEMBERS ...…..…... MemberID MbrFirstName MbrLastName MbrPhoneNumber Gender CPK CPK .………..... PK Entertainment Agency Example Database CUSTOMERS .......... HH CustomerlD CustFirstName CustLastName CustStreetAddress PK HH CustCity CustState CustZipCode CustPhoneNumber MUSICAL PREFERENCES ✰✰✰✰✰✰✰✰✰✰... CustomerID StylelD PreferenceSeq StylelD StyleName ...…...... CPK CPK MUSICAL_STYLES ......... ...... ....... PK HE ENGAGEMENTS EngagementNumber PK StartDate EndDate StartTime Stop Time ContractPrice Customer D AgentID EntertainerID ENTERTAINERS FK FK FK EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEmailAddress DateEntered EntertainerID StylelD StyleStrength PK H ENTERTAINER_STYLES ...….….. CPK CPK Does not include Chapter 20 "driver" tables AGENTS AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhone Number DateHired Salary Commission Rate PK ENTERTAINER_MEMBERS EntertainerID MemberID Status MEMBERS ...…..…... MemberID MbrFirstName MbrLastName MbrPhoneNumber Gender CPK CPK .………..... PK Entertainment Agency Example Database CUSTOMERS .......... HH CustomerlD CustFirstName CustLastName CustStreetAddress PK HH CustCity CustState CustZipCode CustPhoneNumber MUSICAL PREFERENCES ✰✰✰✰✰✰✰✰✰✰... CustomerID StylelD PreferenceSeq StylelD StyleName ...…...... CPK CPK MUSICAL_STYLES ......... ...... ....... PK HE ENGAGEMENTS EngagementNumber PK StartDate EndDate StartTime Stop Time ContractPrice Customer D AgentID EntertainerID ENTERTAINERS FK FK FK EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEmailAddress DateEntered EntertainerID StylelD StyleStrength PK H ENTERTAINER_STYLES ...….….. CPK CPK Does not include Chapter 20 "driver" tables AGENTS AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhone Number DateHired Salary Commission Rate PK ENTERTAINER_MEMBERS EntertainerID MemberID Status MEMBERS ...…..…... MemberID MbrFirstName MbrLastName MbrPhoneNumber Gender CPK CPK .………..... PK Entertainment Agency Example Database CUSTOMERS .......... HH CustomerlD CustFirstName CustLastName CustStreetAddress PK HH CustCity CustState CustZipCode CustPhoneNumber MUSICAL PREFERENCES ✰✰✰✰✰✰✰✰✰✰... CustomerID StylelD PreferenceSeq StylelD StyleName ...…...... CPK CPK MUSICAL_STYLES ......... ...... ....... PK HE ENGAGEMENTS EngagementNumber PK StartDate EndDate StartTime Stop Time ContractPrice Customer D AgentID EntertainerID ENTERTAINERS FK FK FK EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEmailAddress DateEntered EntertainerID StylelD StyleStrength PK H ENTERTAINER_STYLES ...….….. CPK CPK Does not include Chapter 20 "driver" tables AGENTS AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhone Number DateHired Salary Commission Rate PK ENTERTAINER_MEMBERS EntertainerID MemberID Status MEMBERS ...…..…... MemberID MbrFirstName MbrLastName MbrPhoneNumber Gender CPK CPK .………..... PK
Expert Answer:
Answer rating: 100% (QA)
Based on the database schema provided this requires querying multiple tables to calculate the sum of ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these databases questions
-
0.5 Let's work on Z and D values. In the graph below, what are the z-values for each of the curves shown? Can you draw (or explain) what the D-curve would look like at 87C? .6 1x9 9d of 2m992 16dW d...
-
What financial statement, which can be reported with or separate from the income statement, includes income-related items that affect the balance sheet but are not included in net income?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Which 3 accounts can't be merged in the chart of accounts?
-
Express the van der Waals parameters a = 1.32 atm dm6 mol? And b = 0.0436 d3 mol-1 in SI base units.
-
Majer Corporation manufactures a product with the following standard costs: Standard amount or hours Price or Standard Rate Standard cost per unit Direct materials 6.4 ounces ps 3.00 per ounce ps...
-
Freelance reporter Irwin Fletcher is examining the historical voting records of members of the U.S. Congress. For 175 representatives, Irwin has collected the voting record (yes or no) on 16 pieces...
-
Elliott Athletics is trying to determine its optimal capital structure, which now consists of only debt and common equity. The firm does not currently use preferred stock in its capital structure,...
-
1. Identifies the barriers to communication experienced in this scenario as well as their impact. 2. What are the communications barriers that Barry faces? 3. What solutions might Barry consider to...
-
During the current year, Yost Company disposed of three different assets. On January 1 of the current year, prior to the disposal of the assets, the accounts reflected the following: The machines...
-
Given the following interest and exchange rate quotes, a foreign exchange trader at Morgan Stanley (NYSE:MS) concluded that it is NOT possible to make an arbitrage profit through covered interest...
-
When the parent and subsidiary have differing fiscal periods, the fiscal period of the subsidiary can be changed or the financial statements of the subsidiary can be adjusted each period. Current...
-
Which campaign finance loophole was exploited by the energy company Enron, leading to the passage of the Bipartisan Campaign Finance Reform Act of 2002? Multiple choice question. contributions by...
-
Using a company's WACC to evaluate a project is . I) always correct II) always incorrect III) correct for projects that have average risk compared to the firm's other assets
-
Take time to reflect on what you have learned about cryptocurrency in the summary prepared by the senior and use additional resources as necessary. Based on what you know about how Camden Suppliers,...
-
The ageing schedule Question 56 options: a) shows the breakdown of the company's accounts receivable by their date of sale. b) identifies and then tracks delinquent accounts and to see that they are...
-
SHERRI DONATES 5000 TO THE UNIVERSITY IN EXCHANGE FOR THE RIGHT TO PURCHASE TICKETS FOR THE UPCOMING FOOTBALL SEASON. HOW SHOULD SHE TREAT THE CONTRIBUTION? A DEDUCTION IS NOT ALLOWED, B: SHE MAY...
-
A manufacturer can sell product 1 at a profit of $20 per unit and product 2 at a profit of $40 per unit. Three units of raw material are needed to manufacture one unit of product 1, and six units of...
-
. Discuss the duties owed by a partner to her copartners.
-
Donald Petersen joined his father, William Petersen, in a chicken hatchery business William had previously operated as a sole proprietorship. When the partnership was formed, William contributed the...
-
The narrow issue on this appeal is who should bear the loss of a truck and an attached haystack mover that was destroyed by fire while in the possession of the plaintiff, Israel Martin (Martin), but...
-
The NCAA is described as a cartel. In what way is it a cartel? What is the product being produced? How does the cartel stay together?
-
What is the cost to a firm in an oligopoly that fails to take rivals actions into account?
-
The cement industry is an example of an undifferentiated oligopoly. The automobile industry is a differentiated oligopoly. Which of these two is more likely to advertise? Why?
Study smarter with the SolutionInn App