Follow this topic

Last answered:

20 Mar 2023

Posted on:

19 Mar 2023

0

Functions - Incorrect output

in SQL / User-defined functions in MySQL

After running the lesson example, getting an incorrect avg. salary for 11300.

I am getting 63761.28 instead 48193.80

What I am doing wrong here?

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

20 Mar 2023

0

Hi Shivek!
Thanks for reaching out!

Could you please support your question with the entire code you’ve executed? This can help us assist you better. Thank you.

Looking forward to your answer.
Best,
Tsvetelin

Submit an answer

related questions

0

8

IFNULL & COALESCE FUNCTIONS NOT IN MY WORKBENCH

0

8

Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each

1

6

The output shows zero rows returned when you Rollback?

6

6

Can we include answer output for guidance?

Tanmay Chakraborty

0

6

I HAD GIVEN OUTPUT AS SALARY_P BUT WHEN I CALLED THE PROCEDURE IT ALSO ASKING FOR IN OF THE OUT

0

6

I wrote this below code , but the output contained both M and F. I did not got the logic

0

4

Returing a null output

Arowosegbe Victor Iyanuoluwa

0

4

Resolved: Error output received for this query (select first_name, last_name from employees;)

2

4

I wrote a little different code, got only one output

1

4

Resolved: Output parameters

0

2

When will lectures on window functions, common table expressions, temporary tables will be available

0

2

I have solved it using CTE. I have arrived at the similar output.