requete5.sql

来自「a small application in Mysql and Delphi」· SQL 代码 · 共 8 行

CREATE PROCEDURE requte5()
BEGIN
SELECT  code_media ,COUNT(*) nombre_emprunt 
FROM  media NATURAL  JOIN exemplaire NATURAL JOIN emprunt 
GROUP BY code_media 
ORDER BY nombre_emprunt;
END /