Visa 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.
Visa
Explore 10 Visa-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
10
Estimated prep time
170 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Visa-tagged set.
Query basics
10
Aggregation
1
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.
Dormant Promo Codes
Practice query basics through a Visa-tagged business scenario.
Median Google Search Frequency
Practice query basics through a Visa-tagged business scenario.
2024 App Click Volume
Practice query basics through a Visa-tagged business scenario.
Question list
The current Visa-tagged list with learning objectives and your latest status.
Dormant Promo Codes
Marketing launched several promo codes in Q1 2024 and wants to retire the unused ones. Return the promo_code values for codes created between 2024-01-01 and ...
Practice query basics through a Visa-tagged business scenario.
Median Google Search Frequency
At Visa, analysts are preparing a scorecard focused on median google search frequency. Return the weighted median number of searches from the compressed sear...
Practice query basics through a Visa-tagged business scenario.
2024 App Click Volume
Visa wants a manager brief for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Practice query basics through a Visa-tagged business scenario.
Bidirectional Transfer Pairs
Visa is reviewing bidirectional transfer pairs through a trend check. Count unique transfer relationships regardless of direction. Return relationship_count.
Practice query basics through a Visa-tagged business scenario.
Frequent Support Callers
Use this Visa portfolio scan to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort by ...
Practice query basics through a Visa-tagged business scenario.
Second-highest Salary
At Visa, analysts are preparing a portfolio scan focused on second-highest salary. Return the second-highest salary amount in the table as second_highest_sal...
Practice query basics through a Visa-tagged business scenario.
Creators With Multiple 2024 Posts
Use this Visa finance summary 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 Visa-tagged business scenario.
Employee Id And Whether The Employee Met Quota Using Values Yes Or No
Use this Visa readout to work on employee id and whether the employee met quota using values yes or no. Return each employee_id and whether the employee met ...
Practice query basics through a Visa-tagged business scenario.
Average Annual Deal Size Across All Customers
Visa is reviewing average annual deal size across all customers through a trend check. Return the average annual deal size across all customers rounded to tw...
Practice query basics through a Visa-tagged business scenario.
May Orders By Region
Visa wants a readout for may orders by region. Return each region and the number of orders placed during May 2024. Sort by region.
Practice query basics through a Visa-tagged business scenario.