米罗家的药箱

来源: BlogBus 原始链接: http://www.blogbus.com:80/blogbus/blog/diary.php?diaryid=429483 存档链接: https://web.archive.org/web/20041031130512id_/http://www.blogbus.com:80/blogbus/blog/diary.php?diaryid=429483

米罗家的药箱 一只世上最幸福的药箱。里面装着世上最幸福的药片。 <<<TD n°4 SQL (1-8) | 主页 | TD n°4 SQL (18-20)>>> TD n°4 SQL (9-16) 2004-10-07 9. SELECT * FROM R8 WHERE nomecr Like "A"; 10. SELECT prixvente/1.155 AS prixht FROM tarifer; 11. SELECT count(numecr) FROM ecrivain WHERE languecr="Anglais" OR languecr="Allemand"; 12. SELECT sum(qtestock) FROM classification, ouvrage, stocker, depot WHERE classification.numrub=ouvrage.numrub AND ouvrage.numouvr=stocker.numouvr AND stocker.numdep=depot.numdep AND librub="gestion de portefeuilles" AND villedep="Grenoble"; 13. SELECT nomouvr FROM R1, ouvrage, tarifer WHERE ouvrage.numouvr=tarifer.numouvr AND tarifer.prixvente=R1.maxprix; 14. SELECT nomecr, prenomecr, count(numouvr) FROM ecrivain, ecrire WHERE ecrivain.numecr=ecrire.numecr GROUP BY nomecr, prenomecr; 15. SELECT librub, Sum(qtestock) AS nombresto FROM classification, stocker, depot, ouvrage WHERE classification.numrub=ouvrage.numrub AND ouvrage.numouvr=stocker.numouvr AND stocker.numdep=depot.numdep AND depot.villedep="Grenoble" GROUP BY librub; 16. SELECT librub, iif (nombresto>1000, "élevé", "faible") FROM R15; 鸵鸟 发表于 2004-10-07 21:14 引用(Trackback0) Comments 发表评论 最近更新 TD n°4 SQL (18-20) TD n°4 SQL (9-16) TD n°4 SQL (1-8) Tristan et Iseult(2) Tristan et Iseult(1) 日片(17) 日片(16) 日片(15) 日片(14) 小王子(6)