TD n°4 SQL (9-16)

一只世上最幸福的药箱。里面装着世上最幸福的药片。 | 主页 | 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; 鸵鸟 引用(Trackback0) 发表评论 最近更新 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)

原始快照:web.archive.org