Answer for Can you use function inside HAVING clause

https://365datascience.com/dwqa-answer/answer-for-can-you-use-function-inside-having-clause/ -

Hi jo!

Thanks for reaching out and please excuse me for not getting back to you sooner.

This is to reflect the way in which the SQL syntax has been designed. It is indeed the use of alias in the having clause that allows us to apply conditions in the HAVING clause.

You can refer to the following lecture for more information about the only_full_group_by mode and see if reverting to the previous, or old, settings, helps you execute your code.
https://365datascience.teachable.com/courses/360102/lectures/11680913

Hope this helps but please get back to us should you need further assistance. Thank you.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy