**Calculating the Sum and Average of Three Numbers in PL/SQL**

--------------------------------------------------- | Num1 | Num2 | Num3 | Sum | Average | --------------------------------------------------- | 10 | 15 | 20 | 45 | 15 | --------------------------------------------------- | 5 | 12 | 8 | 25 | 8.33 | --------------------------------------------------- | 18 | 25 | 30 | 73 | 24.33 | ---------------------------------------------------

Introduction:

In the world of programming, PL/SQL (Procedural Language/Structured Query Language) plays a vital role in database management and data manipulation. If you're looking to perform calculations on three numbers, specifically finding their sum and average using PL/SQL, this article is for you. We'll guide you through the process, providing a clear explanation and example code snippets to help you understand and implement this task efficiently.

**Query:**

To calculate the sum and average of three numbers in PL/SQL, you can use the following query:

```sql DECLARE num1 NUMBER := 10; -- Replace with your desired value num2 NUMBER := 20; -- Replace with your desired value num3 NUMBER := 30; -- Replace with your desired value sum_result NUMBER; average_result NUMBER; BEGIN sum_result := num1 + num2 + num3; average_result := sum_result / 3; DBMS_OUTPUT.PUT_LINE('Sum: ' || sum_result); DBMS_OUTPUT.PUT_LINE('Average: ' || average_result); END; / ```

**Explanation:**

1. The `DECLARE` keyword is used to define variables that will be used within the PL/SQL block.

2. We declare three variables: `num1`, `num2`, and `num3`, which represent the three numbers you want to calculate the sum and average of. Feel free to replace these values with your desired numbers.

3. Next, we declare `sum_result` and `average_result` variables to store the results of the calculations.

4. The actual calculations are performed within the `BEGIN` and `END;` block. We add `num1`, `num2`, and `num3` together to obtain the sum and assign it to `sum_result`. Then, we divide `sum_result` by 3 to calculate the average and assign it to `average_result`.

5. Finally, we use the `DBMS_OUTPUT.PUT_LINE` function to display the sum and average results in the output console.

**Conclusion:**

In this article, we explored how to calculate the sum and average of three numbers using PL/SQL. We provided you with a query that can be executed in a PL/SQL environment, demonstrating a step-by-step approach to achieve the desired results. By understanding and implementing this query, you'll have the necessary skills to perform similar calculations in your PL/SQL projects.