Snowflake 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.
Snowflake
Explore 9 Snowflake-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
9
Estimated prep time
165 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Snowflake-tagged set.
Query basics
9
Aggregation
2
Date functions
1
Filtering
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.
Late Shipment Rate By Carrier
Practice query basics through a Snowflake-tagged business scenario.
2024 App Click Volume
Practice query basics through a Snowflake-tagged business scenario.
Complete Skill Coverage
Practice query basics through a Snowflake-tagged business scenario.
Question list
The current Snowflake-tagged list with learning objectives and your latest status.
Late Shipment Rate By Carrier
Snowflake is reviewing late shipment rate by carrier through a scorecard. Return the percentage of shipments that arrived late by carrier_name. Output carrie...
Practice query basics through a Snowflake-tagged business scenario.
2024 App Click Volume
At Snowflake, analysts are preparing a trend check focused on 2024 app click volume. Return each app_id and the total number of click events recorded in 2024...
Practice query basics through a Snowflake-tagged business scenario.
Complete Skill Coverage
Snowflake wants a scorecard for complete skill coverage. Return the candidate_id values for candidates who have all three required skills: SQL, Python, and T...
Practice query basics through a Snowflake-tagged business scenario.
Top Sellers By Gross Sales
Snowflake wants a trend check for top sellers by gross sales. Return the top 3 sellers by total_gross_sales. Output seller_id and total_gross_sales sorted by...
Practice query basics through a Snowflake-tagged business scenario.
Frequent Support Callers
Use this Snowflake coverage report to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. So...
Practice query basics through a Snowflake-tagged business scenario.
Creators With Multiple 2024 Posts
Snowflake is reviewing creators with multiple 2024 posts through a health check. Return each creator_id that posted at least two items in 2024. Sort by creat...
Practice query basics through a Snowflake-tagged business scenario.
April Webinar Share
Use this Snowflake scorecard to work on april webinar share. Return the percentage of marketing touches that were webinars in April 2024, rounded to the near...
Practice query basics through a Snowflake-tagged business scenario.
Second-highest Salary
Use this Snowflake operations review to work on second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a Snowflake-tagged business scenario.
May Orders By Region
Snowflake wants a operations review 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 Snowflake-tagged business scenario.