aaa

CREATE OR REPLACE PROCEDURE P1_8_MINSTE_ORDERS AS 
  V_AANTAL_ORDERS NUMBER;
  V_SALES_REP_ID  S_EMP.ID%TYPE;
  V_VOORNAAM      S_EMP.FIRST_NAME%TYPE;
  V_NAAM          S_EMP.LAST_NAME%TYPE;
BEGIN
  SELECT SALES_REP_ID, COUNT(*)
  INTO V_SALES_REP_ID, V_AANTAL_ORDERS
  FROM S_ORD
  GROUP BY SALES_REP_ID
  HAVING COUNT(*) = (SELECT MIN(COUNT(*))
                    FROM S_ORD
                    GROUP BY SALES_REP_ID);  
 
  SELECT FIRST_NAME, LAST_NAME
  INTO V_VOORNAAM, V_NAAM
  FROM S_EMP
  WHERE ID = V_SALES_REP_ID;
 
 DBMS_OUTPUT.PUT_LINE(V_VOORNAAM || ' ' || V_NAAM || ' Met ' || V_AANTAL_ORDERS || ' Orders'); 
 
END P1_8_MINSTE_ORDERS;