Follow this topic

Last answered:

19 Jul 2022

Posted on:

15 Jul 2022

0

Error Code: 1054. Unknown column 'p_avg_salary' in 'field list'

in SQL / Stored routines - conclusion

I received the following error after running code. I am not sure how to resolve. I thought that there might have been something missing in regard tot he function we created, but it seems to be fine. Please help.

Thanks

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

19 Jul 2022

0

Hi Kristin!
Thanks for reaching out.

Could you please share with us the whole code you've executed? Thank you.

Looking forward to your answer.
Best,
Tsvetelin

Submit an answer

related questions

1

16

14. SQL JOINs - Error Code: 1055 (only_full_group_by)

Abdelrahman Samy

0

14

Resolved: why this code not valid

0

14

error code 1140 : in aggregated query without group by

Donald Trenholm

0

14

Resolved: Getting error code 1140 even after trying the fixes.

0

12

Resolved: error 1055 im mysql project

Christopher Watts

1

12

Error Code: 1364. Field 'customer_id' doesn't have a default value

1

12

Resolved: S Error code 1055

Jose Luis Loren

4

12

Alternative code using group by

BAO QUOC NGUYEN

0

10

Resolved: Error Code: player_err_timeout

0

10

Error after Error: Can't create a table this time

1

10

where should I attach the code I executed for assignments

0

10

Resolved: I am getting an error when submitting the 2 codes in the exercise