Easy SOQL & SOSL Practice Problems

Problem Statement

Write a SOQL query using aggregate functions to produce a summary report of Opportunity records grouped by StageName.

For each stage, return the count, total amount, and average amount.

Expected Output Format

Stage         | Count | Total      | Average
Prospecting   |  24   | 1,200,000  | 50,000
Closed Won    |  18   | 4,500,000  | 250,000

Problem Statement

Write a method that returns all Lead records created within the last 30 days, ordered newest-first.

Method Signature

public static List<Lead> getRecentLeads()

Key Concept — Date Literals

SOQL date literals let you write time-relative filters without hardcoding dates. They are written without quotes and some accept a numeric suffix (:N):

WHERE CreatedDate >= LAST_N_DAYS:30

Common date literals:

• TODAY, YESTERDAY, TOMORROW
• THIS_WEEK, LAST_WEEK, NEXT_WEEK
• LAST_N_DAYS:n — the past n days (including today)
• NEXT_N_DAYS:n — the next n days
• THIS_MONTH, LAST_MONTH, NEXT_MONTH

Constraints

• Use a date literal — not a hardcoded date string
• Order by CreatedDate DESC (newest first)
• Return at least Id, FirstName, LastName, CreatedDate

Problem Statement

Write a SOQL query inside getAccountsWithIndustry() that retrieves all Account Name and Industry fields, ordered alphabetically by Name.

Requirements

• Return every Account's Name and Industry.
• Sort the results alphabetically by Account Name.
• Keep the result set to a reasonable page size (200 records).

Problem Statement

List all Closed Won Opportunities with their Name, Amount, and CloseDate, sorted by highest Amount first.

Requirements

• WHERE StageName = 'Closed Won'
• SELECT Name, Amount, CloseDate, AccountId
• ORDER BY Amount DESC

Problem Statement

Write a SOQL query that retrieves the five most recently created Leads, ordered from newest to oldest.

Requirements

• Return each Lead's Id, FirstName, LastName, Email, Company, and CreatedDate.
• Show only the 5 newest Leads, most recent first.

Problem Statement

Compute and return the average Amount of all Closed Won Opportunities as a Decimal. Return 0 if no records exist.

Requirements

• Aggregate the Amount field with an average function, aliasing the aggregate result exactly avgAmt (required for grading)
• Restrict the aggregate to Opportunities that are Closed Won
• Access the aggregate value through its avgAmt alias
• Guard: return 0 if results list is empty

Problem Statement

Return all Opportunities whose CloseDate falls within the next 7 calendar days, ordered soonest-first.

Key Concept — Date Literals

NEXT_N_DAYS:7 matches any date from tomorrow through 7 days from today (inclusive). No Apex date arithmetic is needed.

Requirements

• WHERE CloseDate = NEXT_N_DAYS:7
• ORDER BY CloseDate ASC

Problem Statement

Return all Opportunities whose CloseDate falls within the current calendar month, ordered from earliest to latest close date.

Key Concept

THIS_MONTH covers the entire current month — first day through last day — regardless of today's date.

Requirements

• Filter to Opportunities whose CloseDate falls in the current calendar month, using a date literal — no date-arithmetic bounds.
• Sort the result chronologically by CloseDate, earliest first.

Problem Statement

Aggregate the Lead object to find the total number of Leads in each Lead Source category, ordered from the most to the least common source.

Requirements

• SELECT LeadSource, COUNT(Id) total
• FROM Lead
• GROUP BY LeadSource
• ORDER BY COUNT(Id) DESC

Problem Statement

Retrieve all Accounts whose Billing Postal Code starts with the digit "9".

Key Concept — LIKE Operator

LIKE '9%' in SOQL matches any string beginning with "9". The % wildcard matches zero or more characters.

Requirements

• WHERE BillingPostalCode LIKE '9%'
• SELECT Id, Name, BillingPostalCode
• ORDER BY Name ASC

Problem Statement

Retrieve Opportunities in the "Negotiation" stage that also have an Amount greater than $100,000.

Requirements

• Filter to Opportunities whose StageName is Negotiation and whose Amount exceeds 100,000
• Select Id, Name, Amount, StageName, AccountId
• Sort the results by Amount, highest first

Problem Statement

List all open Opportunities whose CloseDate is within the next 14 days, sorted soonest-to-close first.

Requirements

• WHERE CloseDate <= NEXT_N_DAYS:14
• AND IsClosed = false
• ORDER BY CloseDate ASC

Problem Statement

Return all Opportunities created by a specific user, identified by their Salesforce User Id, ordered most-recent first.

Requirements

• Filter Opportunities to those whose CreatedById matches the passed-in user Id
• Method signature: getOpportunitiesCreatedByUser(Id userId)
• Select Id, Name, Amount, StageName, CreatedDate
• Sort by CreatedDate, most recent first

Problem Statement

Write a child-to-parent SOQL query that retrieves a list of Contacts along with the name of each Contact's parent Account.

Requirements

• Return each Contact's Id, FirstName, LastName, and Email, plus their parent Account's Name.
• Query the Contact object.
• Sort alphabetically by LastName, and cap the result at 20 rows.

Key Concept

Use dot notation (Account.Name) to traverse the relationship from child (Contact) to parent (Account).

Problem Statement

Write a child-to-parent SOQL query that retrieves open Opportunities along with the Industry of their parent Account.

Requirements

• Return each Opportunity's Id, Name, StageName, CloseDate, and Amount, plus its parent Account's Industry.
• Only include Opportunities that are still open.
• Sort by CloseDate, soonest first, and cap the result at 20 rows.

Problem Statement

Retrieve Contacts along with their parent Account's billing address fields (City, State, Country) using child-to-parent SOQL.

Requirements

• Return each Contact's Id, FirstName, LastName, and Email, plus their parent Account's City, State, and Country billing fields.
• Only include Contacts whose Account has a billing city on file.
• Sort by the parent Account's billing country, and cap the result at 20 rows.

Problem Statement

Write a child-to-parent SOQL query that retrieves open Cases with their parent Account name.

Requirements

• Return each Case's Id, CaseNumber, Subject, Status, and Priority, plus its parent Account's Name.
• Only include Cases that are not yet closed.
• Sort by Priority, and cap the result at 20 rows.

Problem Statement

Write a parent-to-child SOQL query that retrieves Accounts together with a list of their related Contacts using a subquery.

Requirements

• Return each Account's Id, Name, Phone, and Website, along with a nested list of its related contacts' Id, FirstName, LastName, and Email.
• Query the Account object.
• Sort alphabetically by Name and cap the results at 10 rows.

Key Concept

Parent-to-child uses a subquery in parentheses to pull related child records inline. Note the plural relationship name for Contacts, not the singular object name.

Problem Statement

Retrieve Accounts with a subquery for their open Opportunities. The subquery should filter and order the child records.

Requirements

• For each Account, return its Id, Name, Industry, and AnnualRevenue, plus a nested list of its still-open opportunities' Id, Name, StageName, Amount, and CloseDate.
• Sort the nested opportunities by their close date, soonest first.
• Sort the outer Account results alphabetically by Name and cap them at 10 rows.

Problem Statement

Inside SOQLPracticeService, implement getAllAccounts() that returns every Account with its Id, Name, and Industry fields.

Requirements

• Return each Account's Id, Name, and Industry.
• Query the Account object with no filtering — every Account should come back.
• Return type: List<Account>

Problem Statement

Implement getAccountsByIndustry(String industryName) that returns all Accounts whose Industry matches the given parameter.

Requirements

• Return each matching Account's Id, Name, and Industry.
• Query the Account object.
• Filter to Accounts whose Industry equals the value passed into the method, using a bind variable rather than string concatenation.

Problem Statement

Implement getTopAccounts() that returns only the first 5 Account records with Id and Name.

Requirements

• Return each Account's Id and Name.
• Query the Account object.
• Cap the number of records returned at 5.

Problem Statement

Implement getAccountsSorted() that returns all Accounts sorted from newest to oldest by CreatedDate.

Requirements

• Return the Id, Name, and CreatedDate of every Account
• Query the Account object
• Sort the results so the most recently created Account comes first

Problem Statement

Implement getAccountsStartsWithA() that returns all Accounts whose Name begins with the letter "A".

Requirements

• SELECT Id, Name
• WHERE Name LIKE 'A%'
• The % wildcard matches any suffix

Problem Statement

Implement getContactsWithEmail() that returns all Contacts where the Email field is populated (not null).

Requirements

• Return the Id, FirstName, LastName, and Email of matching Contacts
• Query the Contact object
• Exclude any Contact whose Email field is blank

Problem Statement

Implement getHighValueOpportunities() that returns all Opportunities with Amount greater than 50,000.

Requirements

• Return the Id, Name, and Amount of matching Opportunities
• Query the Opportunity object
• Only include records whose Amount is strictly greater than 50,000

Problem Statement

Implement getClosedWonOpps() that returns all Opportunities in the "Closed Won" stage.

Requirements

• Return the Id, Name, and StageName of matching Opportunities
• Query the Opportunity object
• Only include records whose stage is exactly "Closed Won"

Problem Statement

Implement getTodayContacts() that returns all Contacts created today using a SOQL date literal.

Requirements

• Return the Id and Name of matching Contacts
• Query the Contact object
• Only include records whose CreatedDate falls within the current day, expressed using a SOQL date literal rather than a hardcoded date

SOQL Date Literals

Date literals like TODAY, YESTERDAY, THIS_WEEK, LAST_N_DAYS:n are evaluated at query time in the user's timezone.

Problem Statement

Implement getAccountCount() that returns the total number of Account records as an Integer.

Requirements

• Use SELECT COUNT() — no field name inside COUNT()
• FROM Account
• Return type: Integer
• A COUNT() query returns an Integer directly, not a list

Problem Statement

Implement getAccountsWithLimitedContacts() that fetches each Account with at most 3 of its Contacts.

Requirements

• Return every Account's Id and Name
• For each Account, include a nested list of its Contacts (Id and LastName), capped at 3 per Account

Problem Statement

Implement getRecentLeads() that returns the 10 most recently created Leads with their Name and Company.

Requirements

• Return the Id, Name, and Company of matching Leads
• Query the Lead object
• Sort so the most recently created Lead comes first, and cap the results at 10 records

Problem Statement

Implement getThisMonthOpportunities() that returns all Opportunities whose CloseDate falls within the current calendar month.

Requirements

• Return the Id, Name, and CloseDate of matching Opportunities
• Query the Opportunity object
• Only include records whose CloseDate falls in the current calendar month, expressed using a SOQL date literal rather than a hardcoded date range

Common Date Literals

• TODAY, YESTERDAY
• THIS_WEEK, LAST_WEEK, NEXT_WEEK
• THIS_MONTH, LAST_MONTH, NEXT_MONTH
• LAST_N_DAYS:n, NEXT_N_DAYS:n

Problem Statement

Implement getAccountsByIndustries() that returns Accounts in the Banking, IT, or Healthcare industries using the IN operator.

Requirements

• Return the Id, Name, and Industry of matching Accounts
• Query the Account object
• Only include records whose Industry is one of Banking, IT, or Healthcare, using the IN operator against that set of values

IN Operator

IN is equivalent to multiple OR conditions. It accepts a comma-separated list of values enclosed in parentheses.

Problem Statement

Write an Apex class ContactDomainQuery with a method getContactsByDomain(String domain) that returns every Contact whose Email ends with @<domain> (e.g. passing "acme.com" should match jane@acme.com).

Requirements

• Build the wildcard pattern into a local String variable first, then bind that variable into the query's LIKE comparison — never concatenate domain directly into the SOQL string.
• Include WITH SECURITY_ENFORCED and an ORDER BY / LIMIT.

Best Practices

• Binding a pre-built String variable (:pattern) instead of splicing user input into the query text is what keeps this SOQL-injection-safe — Apex only allows binding a simple variable reference, not an inline expression, inside LIKE :('%@' + domain).
• WITH SECURITY_ENFORCED enforces field- and object-level security for the running user.
• Always pair an unbounded WHERE clause with a sane LIMIT.

Problem Statement

Write an Apex class AccountsByTypeQuery with a method getAccountsByTypes(List<String> types) that returns every Account whose Type is one of the values in the given list.

Requirements

• Filter to Accounts whose Type matches any value in the bound list parameter.
• Order results by Name ascending.

Best Practices

• Binding a List<String> parameter directly into an IN clause is the standard, injection-safe way to filter against a caller-supplied set of values.
• Always pair with LIMIT even when the input list is short.

Problem Statement

Write an Apex class WonOpportunitiesQuery with a method getWonOpportunities() that returns every won Opportunity, ordered from highest to lowest Amount.

Requirements

• Filter using the standard boolean field IsWon = true — not a picklist comparison against StageName.
• Order by Amount DESC.

Best Practices

• IsWon is a formula-backed boolean that's true for exactly the stage(s) flagged as "won" in Stage Settings — filtering on it is more robust than hardcoding a Stage name like 'Closed Won', since org-specific stage names can vary.

Problem Statement

Write an Apex class UncontactedLeadsQuery with a method getUncontactedLeads() that returns every Lead still at the default "Open - Not Contacted" status, oldest first.

Requirements

• Filter Leads down to exactly that Status value.
• Sort so the oldest, longest-waiting Leads surface first.

Best Practices

• Ordering oldest-first on a queue-style report (like uncontacted Leads) surfaces the records most at risk of going stale, which is usually the actionable priority.

Business Scenario

The support team wants a queue of Cases currently waiting on the customer to respond, oldest first, so nothing silently ages out.

Requirements

• Write an Apex class AwaitingReplyCasesQuery with a method getCasesAwaitingCustomerReply().
• Only include Cases whose status is Awaiting Customer Response.
• Sort the results so the longest-waiting Cases surface first (oldest last-modified first).