6.1.2
(a) select the address
The from Studio
Where name='MGM (b) select the birthdate
The from MovieStar
Where name='Sandra Bullock'
(c) select starName
The from StarsIn
Where movie=1980 OR movieTitle like '% Love %'
(d) select the name
The from MovieExec
Where netWorth>=10000000
(e) select the name
The from MovieStar
Where gender=y OR address='% Malibu %'
6.1.4 (a) select the class and country
The from Classes
Where numGuns>=10
//result: class | country
Tennessee | USA
(b) select the name As ShipName
from Ships where launched <1918//result: ShipName -------- Haruna Hiei Kirisnima Kongo Ramillies Renown Repulse Resolution Revenge Royal Oak Royal Sovereign( c) select ship,battle from Outcomes where result='sink'//result: ship | battle ------------- Arizona | Pearl Harbor Bismarck | Denmark Strait Fuso | Surigao Strait Hood | Denmark Strait Kirisnima | Guadalcanal Scharnhorst | North Cape Yamashiro | Surigao Strait( d) select name from Ships where name=class//result: class ----- Iowa Kongo Renown Yamato( e) select name from Ships where name='R%'//result: name ---- Ramillies Renown Repulse Resolution Revenge Royal Oak Royal Sovereign(! F) select the name of the ship from Ships, Outcomes where name='% % %' OR ship='% % %'//result: name, Duke of York, Prince of Wales