Location:
Search - ssd7 3
Search list
Description: ssd7 exercise 3 ,绝对有用~欢迎下载
Platform: |
Size: 5917 |
Author: wzs |
Hits:
Description: 【SSD7】-EX3答案(queries.sql)2008-08-01 16:48/*1.Display the ID, first name, and joining date of each member whose ID begins with the letters "A%B" or "A&B" and who joined the library no later than Nov. 30, 1997. */ SELECT libid,fname,Join_date FROM MEMBER4 WHERE (libid like 'A\%B%' escape '\' or libid like 'A&B%') and Join_date 1 AND SUM(Qty) > 10 ORDER BY SUM(Qty) ASC /*3.List the IDs and first names of all the members who have read less than 5% of the total number of books read from the library, in non-decreasing order of the number of books read by each.*/ SELECT member4.libid,fname,SUM(TimesRead) AS TotalTimesRead FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid GROUP BY MEMBER4.libid,fname HAVING SUM(TimesRead) 1) ORDER BY fname ASC; /*5.List the names of the suppliers and their respective average quantities of title orders received, whose average quantities of title orders received is more than the average quantity of an order in the system.*/ SELECT SUPPLIER4.name,AVG(Qty) AS Avg_qty FROM SUPPLIER4 INNER JOIN (ORDERED4 INNER JOIN PURCHASE_ORDER4 ON PURCHASE_ORDER4.PoNum = ORDERED4.PoNum) ON SUPPLIER4.Supplier_Id = ORDERED4.Supplier_Id GROUP BY SUPPLIER4.name,ORDERED4.Supplier_Id HAVING AVG(Qty) > (SELECT AVG(Qty) FROM PURCHASE_ORDER4) /*6.List alphabetically the first names and IDs of all the male members of the library who joined before Oct. 10, 1995, who have read only five or fewer different titles, and who have not read the same title twice or more*/ SELECT MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead,COUNT (DISTINCT CallNumber) FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid WHERE MEMBER4.Gender = 'M' AND Join_date < '1995-10-10'AND TimesRead < 2 GROUP BY MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead HAVING COUNT (DISTINCT CallNumber) <= 5
Platform: |
Size: 873693 |
Author: c978645312@163.com |
Hits:
Description: carnegie book ssd7 about database-carnegie book about database ssd7
Platform: |
Size: 336896 |
Author: liutao |
Hits:
Description: icarnegie ssd7电子书带练习版本。chm格式。-icarnegie ssd7 e-book version with practice. chm format.
Platform: |
Size: 1200128 |
Author: 孙瑞 |
Hits:
Description: ssd 电子版 chm 格式的 可以做题而且提交 在卡内基不能上的时候这个很方便的-SSD chm format of the electronic version can be done at the Carnegie Endowment for title and the author can not be on when this is very convenient
Platform: |
Size: 635904 |
Author: kathy |
Hits:
Description: SSD系列教程的SSD7，数据库系统，初步介绍了SQL语言编写。-SSD series of tutorials SSD7, database system, the initial introduction of the SQL language.
Platform: |
Size: 1200128 |
Author: li yang |
Hits:
Description: ssd7卡耐基教程，练习3自己做的答案，可以参考下-Carnegie ssd7 tutorials, practice 3 to do their own answers, you can refer to the following
Platform: |
Size: 5120 |
Author: 贾慧星 |
Hits:
Description: ssd7的练习3，对此练习有疑问的同学可拿去参考-ssd7 practice 3, this practice has undoubtedly taken the students can refer to
Platform: |
Size: 1024 |
Author: Ethan |
Hits:
Description: ssd7 教程 带练习版本 SSD7: Database Systems This course introduces students to database systems.-Tutorials with exercises ssd7 version SSD7: Database Systems This course introduces students to database systems.
Platform: |
Size: 1200128 |
Author: xyf |
Hits:
Description: ssd7 book
ssd7 book
Platform: |
Size: 1200128 |
Author: liutao |
Hits:
Description: ssd7 exercise 3 ,绝对有用~欢迎下载-ssd7 exercise 3, absolutely useful ~ welcome to download
Platform: |
Size: 6144 |
Author: wzs |
Hits:
Description: 卡耐基SSD7- 数据库系统原理，正文内容包括QUIZ和EXERCISE-Carnegie SSD7-database system theory, the body of content, including QUIZ and EXERCISE
Platform: |
Size: 635904 |
Author: zbj |
Hits:
Description: icarnegie ssd7数据库系统网上教材（含练习）-online database system icarnegie ssd7 materials (including practice)
Platform: |
Size: 1199104 |
Author: 陈柳 |
Hits:
Description: ssd6，ssd7，ssd8的英文教程，希望对大家的这三门课的学习有所帮助！-ssd6, ssd7, ssd8 English course, in the hope that all three courses of study that will help!
Platform: |
Size: 3048448 |
Author: liguozheng |
Hits:
Description: ssd7 卡耐基大学课件-ssd7
Platform: |
Size: 1200128 |
Author: 正义 |
Hits:
Description: SSD 7 数据库系统原理 CHM电子书带练习版本-SSD7 CHM Book
Platform: |
Size: 1200128 |
Author: helloman |
Hits:
Description: SSD7 Exercise 3 - Advanced SQL
For this exercise, we will use the library schema. It includes information about book titles in the library, information about library members, about the number of times the books were read by members, about the suppliers who supply books to the library, and about orders placed with the suppliers. -SSD7 Exercise 3- Advanced SQL
For this exercise, we will use the library schema. It includes information about book titles in the library, information about library members, about the number of times the books were read by members, about the suppliers who supply books to the library, and about orders placed with the suppliers.
Platform: |
Size: 23552 |
Author: Fransisco |
Hits:
Description: ssd7课程精华 包括卡耐基课程和课后练习
关于数据库介绍详尽-ssd7 Course Highlights include Carnegie courses and after-school practice on the database describes in detail
Platform: |
Size: 1200128 |
Author: 马睿 |
Hits:
Description: ssd7电子书，带练习。卡内基教程，软件学院学生必备。
-ssd7 e-books, with exercises. Carnegie tutorials, software, college students must have.
Platform: |
Size: 1199104 |
Author: 浩 |
Hits:
Description: SSD系列的chm文件，可以不用登陆卡耐基网站，随时阅读卡耐基教程，非常方便快捷。-You can read the SSD7 and other SSDs without Logining in the iCarnegie website. CHM files are very quick and convenient.
Platform: |
Size: 1200128 |
Author: yujie |
Hits: