Sure, here is a step-by-step guide on how to create the function in PostgreSQL:

1. First, you need to define the function using the `CREATE OR REPLACE FUNCTION` statement. This statement allows you to modify the function if it already exists or create a new one if it doesn't.

2. Then, you specify the name of the function, which is `calculate_salary_bonus` in this case.

3. After that, you define the parameters that the function will take. The function takes two parameters: `employee_id` and `bonus_percentage`.

4. Then, you specify the return type of the function. In this case, the function will return a numeric value which represents the bonus amount.

5. Inside the function, you use a `SELECT` statement to get the salary of the employee with the given `employee_id` from the `employee` table.

6. You calculate the bonus amount by multiplying the salary by the `bonus_percentage` and divide by 100.

7. Finally, you return the bonus amount.

Here is the PL/pgSQL code that implements the above steps:

```sql
CREATE OR REPLACE FUNCTION calculate_salary_bonus(employee_id INT, bonus_percentage NUMERIC)
RETURNS NUMERIC AS $$
DECLARE
employee_salary NUMERIC;
bonus_amount NUMERIC;
BEGIN
SELECT salary INTO employee_salary FROM employee WHERE eid = employee_id;
bonus_amount := (employee_salary * bonus_percentage) / 100;
RETURN bonus_amount;
END; $$
LANGUAGE plpgsql;
```

You can call this function using the following SQL statement:

```sql
SELECT calculate_salary_bonus(1, 10);
```

This will calculate and return the bonus amount for the employee with `eid` 1 and a bonus percentage of 10%.

Question

Sure, here is a step-by-step guide on how to create the function in PostgreSQL:

1. First, you need to define the function using the `CREATE OR REPLACE FUNCTION` statement. This statement allows you to modify the function if it already exists or create a new one if it doesn't.

2. Then, you specify the name of the function, which is `calculate_salary_bonus` in this case.

3. After that, you define the parameters that the function will take. The function takes two parameters: `employee_id` and `bonus_percentage`.

4. Then, you specify the return type of the function. In this case, the function will return a numeric value which represents the bonus amount.

5. Inside the function, you use a `SELECT` statement to get the salary of the employee with the given `employee_id` from the `employee` table.

6. You calculate the bonus amount by multiplying the salary by the `bonus_percentage` and divide by 100.

7. Finally, you return the bonus amount.

Here is the PL/pgSQL code that implements the above steps:

```sql
CREATE OR REPLACE FUNCTION calculate_salary_bonus(employee_id INT, bonus_percentage NUMERIC)
RETURNS NUMERIC AS $$
DECLARE
    employee_salary NUMERIC;
    bonus_amount NUMERIC;
BEGIN
    SELECT salary INTO employee_salary FROM employee WHERE eid = employee_id;
    bonus_amount := (employee_salary * bonus_percentage) / 100;
    RETURN bonus_amount;
END; $$
LANGUAGE plpgsql;
```

You can call this function using the following SQL statement:

```sql
SELECT calculate_salary_bonus(1, 10);
```

This will calculate and return the bonus amount for the employee with `eid` 1 and a bonus percentage of 10%.

Knowee AI · Accepted Answer