Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Song Problem List the clients who live in 'Los Angeles' or who rented CDs containing a song titled 'I Have A Dream. (Hint: use Union)
Song Problem List the clients who live in 'Los Angeles' or who rented CDs containing a song titled 'I Have A Dream. (Hint: use Union) (attributes to retrieve: firstName, lastName, clientID) songCode/cha songTitle/char Sweet Dreams Goodnight Lullab Have A Dream How Could You Breathless Ooh La La client Desert Heat Goldilocks clientlD/char firstName/charlastName/char phone/char address/cha James 480-732-1234 Los Angeles' 480-123-3456 New York 480-123-8588 Los Angeles 480-543-4323 Los Angeles' 480-123-8588 Phoenix 480-566-1289 Detroit 480-500-3400 Phoenix 480-772-8888 Detroit 480-634-1245 Phoenix mi Mamma Mia Broken Life Or Death John ent5 ent6' ent7 Johns Another Day in Paradise Fire Goodni lliams S20 Rentedby cdCode/char seqNumumeric clientiD/chan fromDate/chan toDate/char pricePerDayumberid entg avis 2005-02-05 2005-02-15 0.5 2005-09-05 2005-010-150.3 2005-02-05 2005-02-15 0.5 05-04-15' 0.5 2005-02-05 2005-02-15 0.5 lient3" 2005-03-15' 2005-03-20 0.5 2005-02-05 2005-02-15 0.5 lient3" 2005-02-05' 2005-02-15 0.5 lient3" 2005-12-052006-01-15" 0.1 2005-12-15 2006-02-01 0.5 2005-12-20 2006-01-14 0.5 lient3 2005-12-05'2005-02-15' 0.5 lient2 2005-10-05'2005-11-15' 0.5 lient9 2005-10-05'2005-11-15' 0.5 2005-10-05 2005-11-15' 0.5 lient5' 2005-10-05'2005-11-15' 0.5 2005-10-05' 2005-11-15' 0.5 2005-10-05' 2005-11-15' 0.5 lient5 "2005-11-05,"2005-12-15.10.5 2005-11-05' 2005-12-25' 0.4 Client4' 2005-11-05' 2005-12-15 0.5 Client5' 2005-11-05' 2005-12-15' 0.5 Client6'2005-11-05 2005-12-15' 0.5 Client22005-11-05 2005-12-15' 0.5 cdTitle/char yearlnumerid numberSoldumeric groupCode/cha 2001 ie 05-03-05 Goodnight Sweet Dreams 500000 C3 ent4 1998 2003 2003 1998 2003 2003 2003 800000 800000 750000 le Desert Heat Golden Hits le roke Golden Road 600000 800000 CT le Function Ranch Horse of a Different Color 2001 Rain Color Wonderful 2003 450000 900000 le 2000 2000 1997 1994 1998 2003 2001 2003 Client1 Moon Lake Summer Fiest Kettie Celebrate 40000 89000 99000 25000 75000 800000 790000 C20
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started