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

Answer rating: 100% (QA)

Based on the database schema provided this requires querying multiple tables to calculate the sum of ... View the full answer