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

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

1

6

The output shows zero rows returned when you Rollback?

6

6

Can we include answer output for guidance?

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;)