Answered

Westonci.ca makes finding answers easy, with a community of experts ready to provide you with the information you seek. Experience the ease of finding reliable answers to your questions from a vast community of knowledgeable experts. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

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 :

Emela

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 appreciate your visit. Our platform is always here to offer accurate and reliable answers. Return anytime. Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.