Which two functions can be used together to filter records based on presence of a string within a column’s values?

  • WHERE, COLLECT
  • WHERE, CONCAT
  • WHERE, SIMILAR TO
  • WHERE, LIKE

The correct answer is:

  • WHERE, SIMILAR TO