Greatest and null how to make it work?

Question

SQL

There is such a request

SELECT GREATEST (MAX(`price_click`),MAX(`price_views_1000`),MAX(`price_day`),MAX(`price_week`),MAX(`price_month`),MAX(`price_all_day`),MAX(`price_all_week`),MAX(`price_all_month`)) as value" FROM ....

If at least one MAX returns Null, then the entire query will return Null
Yes, if you can shorten the query ... I would be grateful

Answer 1

Wrap each in IFNULL