6.1.2
(a) select address
from Studio
where name = 'MGM'(b) select birthdate
from MovieStar
where name = 'Sandra Bullock'
(c) select starName
from StarsIn
where movie = 1980 OR movieTitle like '%Love%'
(d) select name
from MovieExec
where netWorth >= 10000000
(e) select name
from MovieStar
where gender = XY OR address = '%Malibu%'
6.1.4( a) select class,country
from Classes
where numGuns >= 10
//result: class | country
Tennessee | USA
( b) select 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 name,ship from Ships,Outcomes where name = '% % %' OR ship = '% % %' //result: name ---- Duke of York Prince of Wales
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/146742.html
標籤：基礎類
上一篇：ggg
下一篇：卷積神經網路