Question

Create a procedure named 'payment_count' which accepts one output parameter p_count with number as its data type. This procedure should print the count of successful payments (response_msg as 'Successful') with alias name as 'successful_payment_count'. Hints: Procedure name : payment_count Output parameter : p_count Table used : payment_authorization Function used : count

Answer 1

this is your answer please check

Answer 2

The program for the given data will be;

IF (

    SELECT

                SUM

     FROM

               Employee

     WHERE

                Client Id

                 And ApplicationID

     <> 1

      BEGIN    

               SET @result =1

      END

ELSE

       BEGIN

                SET @result =0

       END

       AS

       BEGIN

                 IF  (

                       SELECT

                                   SUM ( PAYMENT SUCESSFUL)

#SPJ3