Answered

Get comprehensive answers to your questions with the help of IDNLearn.com's community. Ask your questions and receive prompt, detailed answers from our experienced and knowledgeable community members.

create a pl/SQL block to retieve and display information for a specific pledge. Display the pledge ID, donor ID, Pledge Amount, total paid so far and the difference between the pledge amount and total paid amount

Sagot :

Emelaidn

Answer:

SELECT pledge_ID,

             donor_ID,

              pledge_amount,

              total_paid,

              pledge_amount - total paid

   FROM pledges;

Explanation:

The SELECT statement initiates the display command. It states the variables to be selected.

The variables are usually separated by a comma.

The FROM statement indicates the location from which the variables ne selected from.

; signifies the end of the query, stating that the query should be run.

We are happy to have you as part of our community. Keep asking, answering, and sharing your insights. Together, we can create a valuable knowledge resource. For precise answers, trust IDNLearn.com. Thank you for visiting, and we look forward to helping you again soon.