文件名称:eclipse编程附件\jdic-20060613-bin-windows.zip
- 所属分类：
- 开发工具
- 资源属性：
- [Java] [源码]
- 上传时间：
- 2011-03-18
- 文件大小：
- 853.22kb
- 下载次数：
- 0次
- 提 供 者：
- c978645312@163.com
- 相关连接：
- 无
- 下载说明：
- 别用迅雷下载，失败请重下，重下不扣分！
介绍说明－－下载内容均来自于网络，请自行研究使用
【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
(系统自动生成,下载前可以参看下载内容)
下载文件列表
压缩包 : jdic-20060613-bin-windows.zip 列表 windows/ windows/ChangeLog windows/COPYING windows/demo/ windows/demo/Browser/ windows/demo/Browser/Browser$1.class windows/demo/Browser/Browser$2.class windows/demo/Browser/Browser.class windows/demo/Browser/Browser.java windows/demo/Browser/Browser_jAddressTextField_actionAdapter.class windows/demo/Browser/Browser_jBackButton_actionAdapter.class windows/demo/Browser/Browser_jForwardButton_actionAdapter.class windows/demo/Browser/Browser_jGoButton_actionAdapter.class windows/demo/Browser/Browser_jRefreshButton_actionAdapter.class windows/demo/Browser/Browser_jStopButton_actionAdapter.class windows/demo/Browser/images/ windows/demo/Browser/images/Back.png windows/demo/Browser/images/Forward.png windows/demo/Browser/images/Reload.png windows/demo/Browser/images/Right.gif windows/demo/Browser/images/Stop.png windows/demo/Browser/MyStatusBar.class windows/demo/Browser/MyStatusBar.java windows/demo/FileChooser/ windows/demo/FileChooser/FileChooser$1.class windows/demo/FileChooser/FileChooser.class windows/demo/FileChooser/FileChooser.java windows/demo/FileChooser/FileChooser_jBrowseButton_actionAdapter.class windows/demo/FileChooser/FileChooser_jCreateMailButton_actionAdapter.class windows/demo/FileChooser/FileChooser_jEditButton_actionAdapter.class windows/demo/FileChooser/FileChooser_jFileChooser_propertyChangeAdapter.class windows/demo/FileChooser/FileChooser_jOpenButton_actionAdapter.class windows/demo/FileChooser/FileChooser_jPrintButton_actionAdapter.class windows/demo/FileChooser/FileChooser_jUrlTextField_actionAdapter.class windows/demo/FileExplorer/ windows/demo/FileExplorer/DiskObject.class windows/demo/FileExplorer/DiskObject.java windows/demo/FileExplorer/FileExplorer$1.class windows/demo/FileExplorer/FileExplorer.class windows/demo/FileExplorer/FileExplorer.java windows/demo/FileExplorer/FileExplorer_jAddressTextField_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jBrowseButton_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jMenuItemBrowse_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jMenuItemEdit_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jMenuItemMail_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jMenuItemOpen_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jMenuItemPrint_actionAdapter.class windows/demo/FileExplorer/FileExplorer_jTable_mouseAdapter.class windows/demo/FileExplorer/FileExplorer_jTreeDisk_mouseAdapter.class windows/demo/FileExplorer/FileExplorer_jTreeDisk_treeExpansionAdapter.class windows/demo/FileExplorer/FileExplorer_jTreeDisk_treeSelectionAdapter.class windows/demo/FileExplorer/FileExplorer_jTreeDisk_treeWillExpandAdapter.class windows/demo/FileExplorer/images/ windows/demo/FileExplorer/images/Computer.gif windows/demo/FileExplorer/images/Driver.gif windows/demo/FileExplorer/images/File.gif windows/demo/FileExplorer/images/Folder.gif windows/demo/FileExplorer/images/Right.gif windows/demo/FileExplorer/MyStatusBar.class windows/demo/FileExplorer/MyStatusBar.java windows/demo/FileExplorer/MyTable.class windows/demo/FileExplorer/MyTableModel.class windows/demo/FileExplorer/MyTableModel.java windows/demo/FileExplorer/MyTableRenderer.class windows/demo/FileExplorer/MyTableRenderer.java windows/demo/FileExplorer/MyTreeNode.class windows/demo/FileExplorer/MyTreeNode.java windows/demo/FileExplorer/MyTreeRenderer.class windows/demo/FileExplorer/MyTreeRenderer.java windows/demo/FileExplorer/MyUtility$FileSystemRoot.class windows/demo/FileExplorer/MyUtility.class windows/demo/FileExplorer/MyUtility.java windows/demo/FileTypes/ windows/demo/FileTypes/FileTypes$1.class windows/demo/FileTypes/FileTypes.class windows/demo/FileTypes/FileTypes.java windows/demo/FileTypes/FileTypes_jAddNewActionButton_actionAdapter.class windows/demo/FileTypes/FileTypes_jApplyButton_actionAdapter.class windows/demo/FileTypes/FileTypes_jCancelButton_actionAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonGetExt_itemAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonGetMime_itemAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonRegisterSys_actionAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonRegisterUser_actionAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonUnregisterSys_actionAdapter.class windows/demo/FileTypes/FileTypes_jRadioButtonUnregisterUser_actionAdapter.class windows/demo/JDIC.log windows/demo/README windows/demo/SimpleBrowser/ windows/demo/SimpleBrowser/ImageLinkError$1.class windows/demo/SimpleBrowser/ImageLinkError.class windows/demo/SimpleBrowser/ImageLinkError.java windows/demo/SimpleBrowser/ImageLinkError.java.bak windows/demo/SimpleBrowser/images/ windows/demo/SimpleBrowser/images/Thumbs.db windows/demo/SimpleBrowser/images/Water lilies.jpg windows/demo/SimpleBrowser/JDIC.log windows/demo/SimpleBrowser/SimpleBrowser$1.class windows/demo/SimpleBrowser/SimpleBrowser.class windows/demo/SimpleBrowser/SimpleBrowser.java windows/demo/Tray/ windows/demo/Tray/images/ windows/demo/Tray/images/duke.gif windows/demo/Tray/images/middle.gif windows/demo/Tray/Tray$1.class windows/demo/Tray/Tray$2.class wi