数据库系统基础教程第6章课后习题答案VIP专享VIP免费

Solutions Chapter 6 6.1.1 Attributes must be separated by commas. Thus here B is an alias of A. 6.1.2 a) SELECT address AS Studio_Address FROM Studio WHERE NAME = 'MGM'; b) SELECT birthdate AS Star_Birthdate FROM MovieStar WHERE name = 'Sandra Bullock'; c) SELECT starName FROM StarsIn WHERE movieYear = 1980 OR movieTitle LIKE '%Love%'; However, above query will also return words that have the substring Love e.g. Lover. Below query will only return movies that have title containing the word Love. SELECT starName FROM StarsIn WHERE movieYear = 1980 OR movieTitle LIKE 'Love %' OR movieTitle LIKE '% Love %' OR movieTitle LIKE '% Love' OR movieTitle = 'Love'; d) SELECT name AS Exec_Name FROM MovieExec WHERE netWorth >= 10000000; e) SELECT name AS Star_Name FROM movieStar WHERE gender = 'M' OR address LIKE '% Malibu %'; 6.1.3 a) SELECT model, speed, hd FROM PC WHERE price < 1000 ; MODEL SPEED HD ----- ---------- ------ 1002 2.10 250 1003 1.42 80 1004 2.80 250 1005 3.20 250 1007 2.20 200 1008 2.20 250 1009 2.00 250 1010 2.80 300 1011 1.86 160 1012 2.80 160 1013 3.06 80 11 record(s) selected. b) SELECT model , speed AS gigahertz, hd AS gigabytes FROM PC WHERE price < 1000 ; MODEL GIGAHERTZ GIGABYTES ----- ---------- --------- 1002 2.10 250 1003 1.42 80 1004 2.80 250 1005 3.20 250 1007 2.20 200 1008 2.20 250 1009 2.00 250 1010 2.80 300 1011 1.86 160 1012 2.80 160 1013 3.06 80 11 record(s) selected. c) SELECT maker FROM Product WHERE TYPE = 'printer' ; MAKER ----- D D E E E H H 7 record(s) selected. d) SELECT model, ram , screen FROM Laptop WHERE price > 1500 ; MODEL RAM SCREEN ----- ------ ------- 2001 2048 20.1 2005 1024 17.0 2006 2048 15.4 2010 2048 15.4 4 record(s) se...