Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions

Question

What do Dimensions represent in OLAP Cubes?

Answered: 1 week ago