[GENERAL] Intermediate values and unprivileged users

My apologies if this is an FAQ or considered too general. I have a query like this which returns a single result: SELECT ( (SELECT avg(rel_pressure) as avg4 FROM weather WHERE now() - datetime = '4 hours' ) - (SELECT avg(rel_pressure) as avg24 FROM weather WHERE now() -

Re: [GENERAL] Intermediate values and unprivileged users

Use subselect... SELECT f.foo, (CASE WHEN f.foo 'something' THEN ...) FROM ( SELECT ) f;