What is the main difference between SQL filter and correlation filter in Azure Service Bus

Question

As explained in MSDN (https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters) SQL Filter and Correlation Filter both uses message's system defined and user defined properties.

Can you please provide an example to show the difference among both?

user_59563 · Answer

I have a blog post where all three filter types are explained

There are several differences between correlation and SQL filters. Just to list a few

Within a correlation filter, multiple conditions are AND-ed. SQL filter is much more flexible and can use AND as well as OR operations.
The cost of evaluating filter expression is minimal and almost immediate w/o extra compute required. SQL filters can require more compute but offer more flexibility.