Shortlist the Tech Accounts

Basic

Partner 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

NameIndustry
Acme CloudTechnology
Bluefin BankBanking
Corex LabsTechnology
Delta RetailRetail

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 Name needs 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".

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.