Pinterest 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.
Explore 16 Pinterest-tagged SQL scenarios focused on query basics, joins, 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
16
Estimated prep time
330 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Pinterest-tagged set.
Query basics
14
Joins
5
Date functions
4
Aggregation
3
Filtering
3
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.
Creators With Multiple 2024 Posts
Practice query basics through a Pinterest-tagged business scenario.
2024 App Click Volume
Practice query basics through a Pinterest-tagged business scenario.
Customer Who Visited But Did Not Make Any Transactions
Practice query basics through a Pinterest-tagged business scenario.
Question list
The current Pinterest-tagged list with learning objectives and your latest status.
Creators With Multiple 2024 Posts
Use this Pinterest scorecard 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 Pinterest-tagged business scenario.
2024 App Click Volume
Pinterest wants a analysis pass 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 Pinterest-tagged business scenario.
Customer Who Visited But Did Not Make Any Transactions
Pinterest is reviewing customer who visited but did not make any transactions through a finance summary. Return the distinct policy_holder_id values for memb...
Practice query basics through a Pinterest-tagged business scenario.
Departments Above Average Pay
At Pinterest, analysts are preparing a portfolio scan focused on departments above average pay. Return each department_id whose average salary exceeds the co...
Practice query basics through a Pinterest-tagged business scenario.
Frequent Support Callers
Use this Pinterest reporting cut to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort...
Practice query basics through a Pinterest-tagged business scenario.
Signup Confirmation Rate
At Pinterest, analysts are preparing a readout focused on signup confirmation rate. Calculate the confirmation rate as the percentage of signups that were co...
Practice query basics through a Pinterest-tagged business scenario.
4. Pinterest's Popular Boards
Pinterest users can create and share content in the form of personal "boards". Each board is categorized under a specific theme, such as "Home Decor" or "Tra...
Practice joins through a Pinterest-tagged business scenario.
5. Finding Records in One Table Not Present in Another
To find records in one table that aren't in another, you can use a LEFT JOIN and check for NULL values in the right-side table. Here's an example using two t...
Practice joins through a Pinterest-tagged business scenario.
Cross-Region Sellers
Commerce wants to identify sellers with broad geographic reach. Return seller_id and total_gross_sales for sellers that sold in at least three distinct regio...
Practice query basics through a Pinterest-tagged business scenario.
Final Account Balances
Use this Pinterest operations review to work on final account balances. Calculate the final balance per account_id. Credits add to the balance and debits sub...
Practice query basics through a Pinterest-tagged business scenario.
Duplicate Job Posts
At Pinterest, analysts are preparing a operations review focused on duplicate job posts. Return the number of employers that posted the same role_name in the...
Practice query basics through a Pinterest-tagged business scenario.
Unique Money Transfer Relationships
Use this Pinterest operations review to work on unique money transfer relationships. Count unique transfer relationships regardless of direction. Return rela...
Practice query basics through a Pinterest-tagged business scenario.
Second-highest Salary
Pinterest wants a quality audit for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a Pinterest-tagged business scenario.
May Orders By Region
Pinterest wants a manager brief 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 Pinterest-tagged business scenario.
Unique Orders And Customers Per Month
Use this Pinterest performance snapshot to work on unique orders and customers per month. Return each region and the number of orders placed during May 2024....
Practice query basics through a Pinterest-tagged business scenario.
Customers Buying Every Category
Pinterest wants a operations review for customers buying every category. Return each customer_id that purchased at least one product in every product_categor...
Practice query basics through a Pinterest-tagged business scenario.