数据库系统基础教程第6讲课后习题测试结果.pdfVIP

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