An advanced filter:

allows for $"$OR$,$ AND, and NOT" logic $($i$.$e$.$ Boolean logic$)$ to be applied

always does the same thing a regular filter would do$,$ but in less steps

does the same thing as a database function

cannot except text values to evaluate