READ. UNDERSTAND. PRACTICE.
Coding questions
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
1,899 resources · Page 6 of 80
Coding questions · Mixpanel
Calculate First-Week Retention by Signup Cohort
Compute first-week activity retention by signup-week cohort with all cohort users in the denominator and zero-retention cohorts included.
Coding questions · Meta
Calculate French User Engagement and U.S. Call Duration
This question evaluates proficiency in SQL-based data manipulation and analytics, testing skills such as joining event and profile tables, aggregating metrics, and computing user-level engagement proportions and average durations.
Coding questions · Instacart
Calculate Inventory Purchases with Buy-X-Get-Y-Free Coupons
Calculate exact-cent inventory totals with stock checks and a clearly defined buy-X-get-Y-free coupon, including partial groups and two-decimal output.
Coding questions · Shopify
Calculate Jaccard Similarity Score for Two String Lists
This question evaluates understanding of similarity metrics and competency in comparing string collections, reflecting knowledge of set-theoretic concepts and manipulation of collection data structures used in data processing.
Coding questions · Uber
Calculate January-2024 SF Promotion Impact Using SQL Queries
This question evaluates a candidate's proficiency in relational data manipulation techniques—specifically joins, date and region filtering, aggregation, top‑N identification, and percentage calculations applied to experiment and user-level metrics.
Coding questions · Capital One
Calculate Longest Transaction Streak for Each User
This question evaluates proficiency in data manipulation and time-series sequence analysis, specifically measuring the longest run of consecutive successful transactions per user from transactional logs.
Coding questions · CVS Health
Calculate Medical Claims by Age and Gender in 2024
This question evaluates data manipulation and aggregation competencies using SQL or Python, with emphasis on demographic segmentation and time-based summarization of paid claim amounts.
Coding questions · TikTok
Calculate Monthly Conversion Rate and Average Order Value
This question evaluates the ability to compute monthly conversion rates and average order value from event and transaction data, testing skills in time-based aggregation, joining datasets, distinct user counting, and metric calculation.
Coding questions · Amazon
Calculate Monthly Revenue from Orders in 2023
This question evaluates proficiency in SQL-based data manipulation, including aggregation, date extraction, and combining transactional tables to produce business metrics, and falls under the Data Manipulation (SQL/Python) domain.
Coding questions · Gusto
Calculate Net Pay Change for Q1 2023 Decreases
This question evaluates a candidate's data-manipulation competency in SQL and Python, focusing on computing net pay, aggregating over a calendar quarter, and measuring percentage change between recent pay periods.
Coding questions · DoorDash
Calculate Order Request Metrics
This question evaluates SQL and data-manipulation competencies for computing order-level metrics, including aggregations, joins, windowed event sequencing, timestamp/timezone handling, and NULL-aware comparisons.
Coding questions · Meta
Calculate posts per DAU by country today
This question evaluates data aggregation and join semantics, date-based filtering, inclusion of zero-event users, and numeric rounding when computing average posts per DAU.
Coding questions · Meta
Calculate Recent Post Views and Reactions for Social Media
This question evaluates proficiency in SQL-based data manipulation and analytics, focusing on time-window filtering, grouping and aggregation (distinct counts and averages), and combining view and reaction event tables.
Coding questions · Amazon
Calculate Regional Revenue and Identify Top Customers
This question evaluates proficiency with SQL data manipulation concepts such as joins, aggregation (SUM/GROUP BY), and window functions for ranking customers by spending.
Coding questions · Meta
Calculate Response Rate and Compare New vs. Existing User Scores
This question evaluates data manipulation and statistical analysis skills for a data scientist, focusing on SQL aggregation, NULL handling, cohort comparison, and testing differences in survey scores.
Coding questions · Meta
Calculate Response Rate and Compare User Survey Ratings
This question evaluates data manipulation and analytical skills, including correct SQL join selection, NULL handling, aggregation grain, denominator construction for response rates, and comparative statistics for mean rating differences between cohorts.
Coding questions · IBM
Calculate Revenue from Highest-Inventory VM Sales
Sell each VM unit at its current inventory count, always choose a type with maximum inventory, and compute total revenue safely.
Coding questions · Amazon
Calculate Rolling 7-Day Sum of Answers by Device
This question evaluates proficiency in time-series aggregation and group-wise metric computation on structured data, specifically calculating rolling seven-day sums of answers per device, and assesses familiarity with data manipulation using SQL or Python.
Coding questions · Databricks
Calculate Second-Degree Followers for Each YouTuber
This question evaluates competency in relational data manipulation and graph-style relationship reasoning, including use of joins, aggregation and distinct counting, and is categorized under Data Manipulation (SQL/Python).
Coding questions · Meta
Calculate Shop Visibility Ranking in Search Results
This question evaluates SQL data-manipulation skills including time-windowed aggregations, computation of derived visibility metrics, and ranking operations over event-level impression data.
Coding questions · Meta
Calculate survey response and quality metrics in SQL
This question evaluates SQL proficiency in computing time-windowed metrics, including deduplication, joins between event tables, aggregation, timestamp alignment, and data-quality handling for survey response and score calculations.
Coding questions · Gusto
Calculate Tax from Progressive Brackets
Implement progressive tax calculation with exclusive upper bracket boundaries, integer minor units, and basis-point rates. Focus on marginal slices, one-time rounding, boundary correctness, large inputs, and an efficient linear scan.
Coding questions · Interactive Brokers
Calculate Tax in a Progressive Marginal Tax System
Practice a Interactive Brokers coding interview problem focused on calculate tax in a progressive marginal tax system. The prompt emphasizes edge cases, clean implementation, and verifiable test behavior without revealing the solution.
Coding questions · Airbnb
Calculate the Median House Price in Each City
Calculate median house prices by city in PostgreSQL, handling odd and even group sizes, repeated prices, and exact numeric results.