Filter where contains partial text in Google Sheets QUERY

An example of how to filter where contains partial text in Google Sheets QUERY