Which of the following SOQL statements is used for retrieving the fields: FirstName, LastName and Department from the Employee table such that the FirstName is either Jack or Mary?

Select FirstName. LastName, Department from Employee where FirstName in ('Jack', 'Mary‘)

Select FirstName. LastName, Department from Employee where FirstName ('Jack' II 'Mary')

Select FirstName. LastName, Department from Employee having FirstName ('Jack', 'Mary')

Select FirstName. LastName, Department from Employee if FirstName like ('Jack', 'Mary')

Answer:
Select FirstName. LastName, Department from Employee where FirstName in ('Jack', 'Mary‘)

Note: This Question is unanswered, help us to find answer for this one