CUSTOMER_STATS

CREATE OR REPLACE
PROCEDURE customerStats (
                        v_email "User".email%TYPE
                        ) AS
CURSOR res IS SELECT * FROM Reservation;
CURSOR train IS SELECT * FROM TrainRide;

counter INT;
login INT;
BEGIN

SELECT iduser INTO login FROM "User" WHERE email = v_email;
DBMS_OUTPUT.PUT_LINE('USER: ' || v_email || 'HAS USED: ' );

FOR i IN train LOOP
counter :=  0;
  FOR j IN res LOOP
    IF (j.idTrainRide = i.idTrainRide AND j.iduser = login) THEN
    counter := counter + 1;
    END IF;
  END LOOP;
  IF (counter > 0) THEN
  DBMS_OUTPUT.PUT_LINE('TRAIN: ' || i.idTrainRide || ': ' || counter || ' TIMES' );
  END IF;
END LOOP;


END;