Sample HW5 Solution

Bid color blue red green e find unique

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o are over 30 years old or have reserved a red boat. Solution: select f rom w here U NION s elect f rom w here a nd a nd S.sid, S.name, S.age Sailors S S.age > 30 S.sid, S.name, S.age Sailors S, Reserves R, Boats B S.sid = R.sid B.bid = R.bid B.color = 'red'; SID NAME AGE - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 22 Dustin 45 29 Brutus 33 31 Lubber 56 58 Rusty 35 64 Horatio 35 74 Horatio 35 95 Bob 62 (c) Find the colors of boats reserved by any s...
View Full Document

Ask a homework question - tutors are online