jljl

CREATE OR REPLACE PROCEDURE P3_4_MINSTE_ORDERS AS 
  CURSOR C_ORDERS IS
  SELECT LAST_NAME, FIRST_NAME 
  FROM S_EMP 
  WHERE ID = (
    SELECT SALES_REP_ID
    FROM S_ORD
    GROUP BY SALES_REP_ID
    HAVING COUNT(*) = (SELECT MIN(COUNT(*))
                       FROM S_ORD
                       GROUP BY SALES_REP_ID));  
  R_ORDER C_ORDERS%ROWTYPE;
BEGIN
  OPEN C_ORDERS;
    FETCH C_ORDERS INTO R_ORDER;
    IF C_ORDERS%FOUND THEN
      DBMS_OUTPUT.PUT_LINE(R_ORDER.LAST_NAME || ' ' || R_ORDER.FIRST_NAME);
    END IF;
END P3_4_MINSTE_ORDERS;