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

• SELECT Name and Industry
• FROM Account
• ORDER BY Name ASC
• LIMIT 200

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

• SELECT Id, FirstName, LastName, Email, Company, CreatedDate
• FROM Lead
• ORDER BY CreatedDate DESC
• LIMIT 5

Problem Statement

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

Requirements

• Use AVG(Amount) avgAmt
• WHERE StageName = 'Closed Won'
• Access result: (Decimal) results[0].get('avgAmt')
• 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

• WHERE CloseDate = THIS_MONTH
• ORDER BY CloseDate ASC

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

• WHERE StageName = 'Negotiation' AND Amount > 100000
• SELECT Id, Name, Amount, StageName, AccountId
• ORDER BY Amount DESC

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

• WHERE CreatedById = :userId
• Method signature: getOpportunitiesCreatedByUser(Id userId)
• SELECT Id, Name, Amount, StageName, CreatedDate
• ORDER BY CreatedDate DESC

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

• SELECT: Id, FirstName, LastName, Email, Account.Name
• FROM Contact
• ORDER BY LastName ASC, LIMIT 20

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

• SELECT: Id, Name, StageName, CloseDate, Amount, Account.Industry
• FROM Opportunity WHERE IsClosed = false
• ORDER BY CloseDate ASC, LIMIT 20

Problem Statement

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

Requirements

• SELECT: Id, FirstName, LastName, Email, Account.BillingCity, Account.BillingState, Account.BillingCountry
• FROM Contact WHERE Account.BillingCity != null
• ORDER BY Account.BillingCountry ASC, LIMIT 20

Problem Statement

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

Requirements

• SELECT: Id, CaseNumber, Subject, Status, Priority, Account.Name
• FROM Case WHERE Status != 'Closed'
• ORDER BY Priority ASC, LIMIT 20

Problem Statement

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

Requirements

• SELECT: Id, Name, Phone, Website, plus a subquery: (SELECT Id, FirstName, LastName, Email FROM Contacts)
• FROM Account
• ORDER BY Name ASC, LIMIT 10

Key Concept

Parent-to-child uses a subquery in parentheses: (SELECT ... FROM Contacts). Note the plural relationship name Contacts, not Contact.

Problem Statement

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

Requirements

• Subquery: (SELECT Id, Name, StageName, Amount, CloseDate FROM Opportunities WHERE IsClosed = false ORDER BY CloseDate ASC)
• Outer: FROM Account, ORDER BY Name ASC, LIMIT 10

Problem Statement

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

Requirements

• SELECT Id, Name, Industry
• FROM Account
• Return type: List<Account>

Problem Statement

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

Requirements

• SELECT Id, Name, Industry
• FROM Account
• WHERE Industry = :industryName (bind variable)

Problem Statement

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

Requirements

• SELECT Id, Name
• FROM Account
• LIMIT 5

Problem Statement

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

Requirements

• SELECT Id, Name, CreatedDate
• FROM Account
• ORDER BY CreatedDate DESC

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

• SELECT Id, FirstName, LastName, Email
• FROM Contact
• WHERE Email != null

Problem Statement

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

Requirements

• SELECT Id, Name, Amount
• FROM Opportunity
• WHERE Amount > 50000

Problem Statement

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

Requirements

• SELECT Id, Name, StageName
• FROM Opportunity
• WHERE StageName = 'Closed Won'

Problem Statement

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

Requirements

• SELECT Id, Name
• FROM Contact
• WHERE CreatedDate = TODAY

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

• Outer: SELECT Id, Name FROM Account
• Subquery: (SELECT Id, LastName FROM Contacts LIMIT 3)

Problem Statement

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

Requirements

• SELECT Id, Name, Company
• FROM Lead
• ORDER BY CreatedDate DESC
• LIMIT 10

Problem Statement

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

Requirements

• SELECT Id, Name, CloseDate
• FROM Opportunity
• WHERE CloseDate = THIS_MONTH

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

• SELECT Id, Name, Industry
• FROM Account
• WHERE Industry IN ('Banking', 'IT', 'Healthcare')

IN Operator

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