We are planning a postcard mailing to promote our performers who play Show Tunes or Standards. Using the EntertainmentAgencyModify database, list the full name and mailing address for all customers who did not book any performers in 2018 who play Show Tunes or Standards so that we can include them in the mailing. (Hint: help make a subquery to list all customers who DID book performers who play those musical styles and then test for NULL to see which customers are not in that list) You must use the names of the musical styles, not the styleID numbers. (7 rows)

 

Transcribed Image Text:

Agents AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhoneNumber DateHired Salary CommissionRate Entertainers EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEMailAddress DateEntered EntPricePerDay 88L Engagements Engagement Number StartDate EndDate StartTime Stop Time ContractPrice CustomerlD AgentID EntertainerID Entertainer_Members EntertainerID MemberlD Status Entertainer_Styles EntertainerID StylelD Customers CustomerlD CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode CustPhoneNumber Members Musical Styles StylelD StyleName MemberlD MbrFirstName MbrLastName MbrPhoneNumber Gender 818L Musical Preferences ? CustomerID StylelD Engagements Archive Engagement Number StartDate EndDate StartTime Stop Time ContractPrice CustomerID AgentID EntertainerID Agents AgentID AgtFirstName AgtLastName AgtStreetAddress AgtCity AgtState AgtZipCode AgtPhoneNumber DateHired Salary CommissionRate Entertainers EntertainerID EntStageName EntSSN EntStreetAddress EntCity EntState EntZipCode EntPhoneNumber EntWebPage EntEMailAddress DateEntered EntPricePerDay 88L Engagements Engagement Number StartDate EndDate StartTime Stop Time ContractPrice CustomerlD AgentID EntertainerID Entertainer_Members EntertainerID MemberlD Status Entertainer_Styles EntertainerID StylelD Customers CustomerlD CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode CustPhoneNumber Members Musical Styles StylelD StyleName MemberlD MbrFirstName MbrLastName MbrPhoneNumber Gender 818L Musical Preferences ? CustomerID StylelD Engagements Archive Engagement Number StartDate EndDate StartTime Stop Time ContractPrice CustomerID AgentID EntertainerID

Answer rating: 100% (QA)

Solution Schema AgentsAgentIDagtFirstNameagtStreetAddressAgtCityagtStateAgtZipCodeagtPhoneNumberSalaryCommissionRate EnagementsEngagmenetNumberstartDa... View the full answer