Find the Partner Domain Contacts

Basic

Acme is moving to a new email platform, and IT wants every contact who has an acme.com address.

Return LastName and Email for every Contact whose email address ends with @acme.com.

Sample data

Expected result on the sample

Row order does not matter. Only the columns above are compared; extra columns in your SELECT are fine.

Hints
  • % matches any number of characters.
  • Include the @ in the pattern.

What this tests

LIKE with % handles prefix, suffix and contains matches, and it is case-insensitive. Anchoring the pattern on @acme.com instead of acme.com matters: without the @, addresses like notacme.com match too. Leading wildcards cannot use an index, so on large objects pair them with a selective filter.

SOQL

Run on sample executes your query against the sample data shown on the left and displays the rows it returns. Submit checks it against the sample plus 2 hidden datasets, comparing your rows with the expected rows on each. Queries run in a real Salesforce org; the data is inserted for your run and rolled back afterwards.