READ. UNDERSTAND. PRACTICE.
Coding questions
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
1,899 resources · Page 5 of 80
Coding questions
Build SQL pivot with lookups and currency conversion
This question evaluates proficiency in data manipulation using SQL or SQL-like Python transforms, covering point-in-time currency conversion, temporal joins for FX lookups, joins to enrich product/customer metadata, aggregation and pivot-style reporting, ranking, and data-quality checks for missing FX.
Coding questions · Amazon
Calculate 7-Day Rolling Average for Energy Consumption
This question evaluates programming fluency in numerical data processing and algorithmic implementation for computing moving averages and handling edge cases in time-series sequences, and it applies to Data Scientist roles while falling under the Coding & Algorithms category.
Coding questions · Pinterest
Calculate 95% Bootstrap Confidence Interval for Order Values
This question evaluates a data scientist's competence in statistical inference using bootstrap resampling, proficiency with numerical computing for large sample operations, and attention to performance optimization.
Coding questions · Instacart
Calculate a Basket Total from Delimited Product Records
Parse SKU, product, quantity, and integer-cent prices to calculate a basket total, with repeated records, zero quantities, and exact integer arithmetic.
Coding questions · Meta
Calculate Ad Performance with Click-Through and Conversion Rates
This question evaluates a candidate's competency in designing and computing ad-performance KPIs by performing data manipulation, joining event tables, applying time-window filters, and aggregating metrics using SQL or Python.
Coding questions · Coinbase
Calculate Adoption and Transaction Rates, Identify Cross-Region Sales
This question evaluates data manipulation and analytics skills in SQL/Python, focusing on aggregation, event-time calculations, and identifying cross-region transaction behavior to compute adoption and transaction rates.
Coding questions · Meta
Calculate and Compare Survey Response Rates for User Tenure
This question evaluates proficiency in relational data manipulation and metric computation, including SQL joins, aggregation and cohort-based comparisons relevant to survey response analysis, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role.
Coding questions · PayPal
Calculate and Find Average Contacts and Sync Percentage
This question evaluates proficiency in data aggregation, deduplication, and relational joins for computing user-level metrics such as average synced contacts and the percentage of users with at least one synced contact.
Coding questions · CVS Health
Calculate annual percentages and YoY by cohorts
This question evaluates SQL and pandas data manipulation skills, specifically joins, conditional aggregation, deduplication, cohort-based percentage computations, and year-over-year change calculations.
Coding questions · Upstart
Calculate Average Event Value by User ID
This question evaluates a candidate's skill in group-wise aggregation and data transformation on JSON-like event streams, specifically computing per-user average metrics and producing ranked results.
Coding questions · CloudTrucks
Calculate Average Rate and Cumulative Jobs by State
This question evaluates competency in relational data manipulation and analytical SQL concepts—including joins, aggregation with DISTINCT counts, per-date averaging, rolling cumulative counts, and handling numeric edge cases—within the Data Manipulation (SQL/Python) domain for a data scientist role.
Coding questions · Meta
Calculate Average Session Duration and Performance Metrics
This question evaluates proficiency in data manipulation and analytics, focusing on session-level time calculations, user behavior metrics such as bounce rate, performance metric definition, and revenue attribution using SQL and Python.
Coding questions · Meta
Calculate Average Session Length and Compare App Performance
This question evaluates sessionization, time-based aggregation, and metric design competencies using SQL and Python, testing a data scientist's ability to process timestamped logs, compute engagement metrics, and interpret user-switching behavior within the Data Manipulation domain.
Coding questions · TikTok
Calculate Conversion Rate from Ad Clicks to Page Visits
This question evaluates a candidate's competency in event-level data manipulation and metric computation using SQL or Python, including time-based aggregation, deduplication, and joining or windowing of event streams.
Coding questions · MathWorks
Calculate cost from orders with SQL
This question evaluates a candidate's ability to perform SQL data manipulation and business-rule calculations, including conditional joins, date-range filtering, and numeric arithmetic for discounts and taxes.
Coding questions · DoorDash
Calculate Courier Earnings
This question evaluates algorithmic problem-solving with emphasis on temporal interval aggregation, handling overlapping events, and applying conditional rate multipliers under specified business rules.
Coding questions · Amazon
Calculate cross-channel login user proportions
This question evaluates data manipulation (SQL/Python) skills, focusing on cross-channel user attribution, deduplication, distinct user counting, date-window filtering, join logic, efficient aggregation for large tables, and formatted output of counts and percentages in ANSI SQL-compatible queries.
Coding questions · Coinbase
Calculate Cumulative Sum for Each Integer in Table
This question evaluates competency in cumulative aggregation and ordering within SQL and related data-manipulation tools, focusing on calculating running totals across rows. It is commonly asked to measure practical application skills in the Data Manipulation (SQL/Python) domain, testing query formulation, efficiency and aggregation semantics at a practical application level.
Coding questions · Meta
Calculate Daily Harmful Content View Percentage
This question evaluates proficiency in data manipulation and aggregation for computing event-based metrics, testing competency in SQL/Python data processing within the Data Manipulation (SQL/Python) domain.
Coding questions · Meta
Calculate Daily Visibility Score for Each Shop
This question evaluates a candidate's ability to perform conditional aggregation and time-based grouping to compute derived metrics such as impressions, views, and a visibility ratio per shop and calendar day.
Coding questions · TikTok
Calculate Day-7 Retention Rate from User Post Data
This question evaluates a candidate's competency in SQL and Python data wrangling, emphasizing date arithmetic, window functions, grouping, and conditional aggregation for cohort and retention calculations.
Coding questions · Amazon
Calculate Defect Rate and Identify Top Lanes for Carriers
This question evaluates competency in SQL-based data manipulation for a data scientist role, covering joins, aggregations, date-based filtering, metric computation, and use of window functions to derive week-over-week changes.
Coding questions · Meta
Calculate Distinct High-View Posts and Spam View-Prevalence
This question evaluates proficiency in SQL-based data manipulation and analytical querying, including joins, aggregation, time-window filtering, and proportion calculations for operational metrics.
Coding questions · Meta
Calculate Engagement Metrics for Info-Stream Content Analysis
This question evaluates proficiency in data manipulation and analytics using SQL and Python, including aggregations, grouping, joins, and handling time-based event data to compute engagement metrics.