Write SOQL Queries

Concepts

SOQL reads records. Write it inline in square brackets, filter with WHERE, and sort with ORDER BY. Bind Apex variables with a colon.

Hands-On Challenge

1. Create a class ContactSearch with a static method searchForContacts(String lastName, String postalCode).
2. Return the ID and Name of contacts that match both values.

List<Contact> results = [SELECT Id, Name FROM Contact
                          WHERE LastName = :lastName AND MailingPostalCode = :postalCode];