Find pairs consisting of an entertainer and an agent who both live within the same zip code
Fantastic news! We've Found the answer you've been seeking!
Question:
Find pairs consisting of an entertainer and an agent who both live within the same zip code area and cooperated in an engagement that ended four days after its start date. Tables to be used: AGENTS, ENGAGEMENTS, ENTERTAINERS. You should obtain the following result set:
AGENT
ENTSTAGENAME
John Kennedy
Country Feeling
Ex.2 (10 points). EntertainmentAgencyExample
Find contract price for an engagement that involved a customer preferring Folk music and an entertainer who plays this style. Tables to be used: CUSTOMERS, MUSICAL PREFERENCES, MUSICAL_ STYLES, ENGAGEMENTS, ENTERTAINER STYLES. You should get the following result set:
CONTRACTPRICE
200
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: