In Salesforce SOQL (Salesforce Object Query Language), to combine a LIKE statement with an IN statement, you usually have to split them into separate parts of the query because IN is typically used…