Check out example codes for "mysql where derived column". It will help you in understanding the concepts better.

Code Example 1

#you can use having on derived columns.
SELECT a,b,c,(a*b+c) AS d, n FROM table
HAVING d > n
ORDER by d

Learn ReactJs, React Native from akashmittal.com