This is a repository of sample tasks using SOQL that you can complete in Code Builder or VS Code using the Salesforce Extensions. We’ll keep adding to this list, so make sure you visit this topic often.

1. From the Command Palette, run SFDX: Create Query in SOQL Builder to open SOQL Query Builder.
2. Click File > Save to save the query. Make sure to retain the .soql file extension.
3. Click the Switch Between SOQL Builder and Text Editors icon ( ) to reopen the SOQL Query Builder.
4. In the From field, search for the object, and then select the Account object.
5. In Fields, select Name, BillingState, and BillingCountry.
6. In the Filter field, select AND, and set: BillingCountry = USA AND BillingState = NY
7. Click Run Query.

A Query Result tab pops up. You can then save the result in csv or json formats.

Guides:

• Example SELECT Clauses
• Salesforce Object Query Language (SOQL)

Trailhead:

• Write SOQL Queries