Shortlist the Tech Accounts
Basic SolvedPartner marketing is running a campaign for software companies and needs every account tagged with the Technology industry.
Return the Name of every Account whose Industry is Technology.
Sample data
Account 4 records
| Name | Industry |
|---|---|
| Acme Cloud | Technology |
| Bluefin Bank | Banking |
| Corex Labs | Technology |
| Delta Retail | Retail |
Expected result on the sample
| Name |
|---|
| Acme Cloud |
| Corex Labs |
Row order does not matter. Only the columns above are compared; extra columns in your SELECT are fine.
Hints
- Picklist fields are filtered like text:
Field = 'Value'. - Only
Nameneeds to be in the SELECT list.
What this tests
An equality filter on a picklist is the most common WHERE clause you will write. Picklist values compare as exact strings, and text comparison in SOQL is case-insensitive. Filtering on the picklist rather than on words in the account name is what keeps the result correct when a name happens to contain "Tech".
Datasets
Solved on this device only. Sign in with Google to keep your progress across devices.
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.