Salesforce practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Salesforce
Explore 12 Salesforce-tagged SQL scenarios focused on query basics, aggregation, date functions.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
12
Estimated prep time
200 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Salesforce-tagged set.
Query basics
10
Aggregation
2
Date functions
1
Filtering
1
Joins
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Partner Contracts Expiring Soon
Practice query basics through a Salesforce-tagged business scenario.
Alternating Measurement Totals
Practice query basics through a Salesforce-tagged business scenario.
Creators With Multiple 2024 Posts
Practice query basics through a Salesforce-tagged business scenario.
Question list
The current Salesforce-tagged list with learning objectives and your latest status.
Partner Contracts Expiring Soon
Partnership ops wants a list of non-renewing contracts that are about to end. Using 2024-11-01 as the reference date, return partner_id, region, and end_date...
Practice query basics through a Salesforce-tagged business scenario.
Alternating Measurement Totals
Salesforce wants a scorecard for alternating measurement totals. Return separate totals for odd-numbered and even-numbered measurement days. Return two colum...
Practice query basics through a Salesforce-tagged business scenario.
Creators With Multiple 2024 Posts
Use this Salesforce readout to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a Salesforce-tagged business scenario.
Customers Sharing Same
Salesforce is reviewing customers sharing same through a scorecard. Return each customer pair that purchased the same order on the same day. Output customer_...
Practice query basics through a Salesforce-tagged business scenario.
Frequent Support Callers
Salesforce is reviewing frequent support callers through a performance snapshot. Return the distinct policy_holder_id values for members who made at least 3 ...
Practice query basics through a Salesforce-tagged business scenario.
Patient Support Analysis (part 3)
At Salesforce, analysts are preparing a weekly brief focused on patient support analysis (part 3). Return the distinct policy_holder_id values for members wh...
Practice query basics through a Salesforce-tagged business scenario.
2024 App Click Volume
At Salesforce, analysts are preparing a backlog scan focused on 2024 app click volume. Return each app_id and the total number of click events recorded in 20...
Practice query basics through a Salesforce-tagged business scenario.
Signup Confirmation Rate
Salesforce wants a portfolio scan for signup confirmation rate. Calculate the confirmation rate as the percentage of signups that were confirmed. Return conf...
Practice query basics through a Salesforce-tagged business scenario.
7. What's the difference between an inner and a full outer join
A **full outer join** returns all rows from both tables, including any unmatched rows, whereas an **inner join** only returns rows that match the join condit...
Practice joins through a Salesforce-tagged business scenario.
15 Easy Salesforce Average Deal Size Part 1
--Average Deal Size-- select round(avg(num_seats * yearly_seat_cost),2) as average_deal_size from contracts
Practice aggregation through a Salesforce-tagged business scenario.
Monthly Reactivated Users
At Salesforce, analysts are preparing a operations review focused on monthly reactivated users. Count how many users logged in during a month after being ina...
Practice query basics through a Salesforce-tagged business scenario.
Late Shipment Rate By Carrier
Salesforce wants a planning note for late shipment rate by carrier. Return the percentage of shipments that arrived late by carrier_name. Output carrier_name...
Practice query basics through a Salesforce-tagged business scenario.