Filters can be used inside the queries function

Example:

SHOW F(G() WHERE A > B)

Here, filter WHERE A > B is applied on G().Fis a function and G, A, and B can either be function or field or expression or literal.

SHOW SUM(SALES WHEN DISCOUNT > 200 )

SHOW SUM(SALES WHEN PROFIT > DISCOUNT )