READ. UNDERSTAND. PRACTICE.
Coding questions
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
1,899 resources · Page 43 of 80
Coding questions · Together
Historical Lookups in a Timestamped Key-Value Store
Implement historical key-value lookups using timestamped writes, per-key ordered histories, and binary search for the latest eligible value.
Coding questions · Meta
How do you expand nested placeholders in strings?
This intermediate-level Coding & Algorithms problem for Data Scientist roles evaluates string parsing and manipulation skills along with dependency resolution techniques such as recursion or graph traversal, cycle detection, and memoization.
Coding questions · Pinterest
How to Design a Proportional Randomized Sampler?
This question evaluates proficiency in randomized algorithms and probabilistic sampling, with emphasis on numerical precision, large-weight handling, and memory-versus-accuracy trade-offs. Commonly asked in Coding & Algorithms interviews for data-science roles, it assesses practical application ability grounded in conceptual understanding of numerical stability and relevant data-structure choices.
Coding questions · Hopper
How would you sort filenames with numeric segments?
This question evaluates a candidate's ability to design custom string comparators, parse maximal digit runs and compare numeric values, and handle edge cases such as leading zeros and digit-versus-non-digit ordering.
Coding questions · Meta
Identify 3-Person Call Cycles in Video-Calling App
This question evaluates SQL data-manipulation competency, including aggregation, distinct counting, date filtering and relational pattern detection (three-node cycles) to measure user engagement and group-call signals.
Coding questions · LinkedIn
Identify and Flag Bot Traffic in Online Forum
This question evaluates the candidate's ability to manipulate time-series event data and implement heuristic-based anomaly detection using SQL and Python, focusing on identifying and handling automated bot traffic.
Coding questions · Capital One
Identify country with highest sunny-day probability
This question evaluates data manipulation competencies including SQL aggregation, NULL handling, case-insensitive condition matching, date-level deduplication, probability calculation, and multi-criteria ordering.
Coding questions · Amazon
Identify Customers Purchasing Every Product in Catalog
The question evaluates a candidate's ability to perform data manipulation in SQL or Python, focusing on aggregation, grouping, and set-coverage concepts (relational division) to determine which customers have purchased every product in a catalog.
Coding questions · Amazon
Identify Date with Highest Total kWh Consumption Using Pandas
This question evaluates proficiency in pandas-based data manipulation and time-series aggregation, specifically the competency to aggregate and summarize meter readings to identify peak consumption dates.
Coding questions · Meta
Identify Duplicate Posts by User and Date
This question evaluates a candidate's competency in data manipulation and deduplication, focusing on aggregation and handling of temporal attributes to identify repeated entries by the same user.
Coding questions · Amazon
Identify Employees with Invalid Department References
This question evaluates SQL data manipulation skills and data-quality reasoning, specifically assessing understanding of referential integrity and the detection of orphaned foreign-key references between related tables.
Coding questions · Amazon
Identify First Daily Order for Each Merchant
This question evaluates proficiency in data manipulation with SQL and related tools, focusing on identifying the first transaction per merchant for each calendar date and handling ordering and deduplication within grouped transactional records.
Coding questions · Amazon
Identify Frequent Actor-Director Collaborations in Film Database
This question evaluates competency in relational data manipulation and aggregation, specifically the ability to identify repeated actor–director relationships using SQL or Python data tools.
Coding questions · Amazon
Identify Key Metrics for Monitoring Shipment Defects
This question evaluates a data scientist's skill in defining and computing operational monitoring metrics for shipment defects, emphasizing data manipulation, aggregation, and metric definition using SQL and Python.
Coding questions · Shopify
Identify Pirate-Themed Custom Themes Using Jaccard Similarity
This question evaluates understanding of similarity metrics (Jaccard similarity), set-based data representations, and the competency to implement and reason about list- or token-level similarity comparisons.
Coding questions · TikTok
Identify Repeat Advertisers from Consecutive Weeks
This question evaluates a candidate's proficiency in manipulating relational data to identify recurring entities across consecutive time periods, focusing on SQL/Python data manipulation and temporal comparison of records.
Coding questions · PayPal
Identify Session with Maximum Overlapping Sessions Count
This question evaluates temporal interval reasoning, set-based querying and aggregation skills, focusing on identifying and counting overlapping time intervals using SQL or equivalent Python data-manipulation tools.
Coding questions · Meta
Identify Shops with Low Weekly Visibility Rates
This question evaluates a candidate's competence in SQL data manipulation and analytical metrics, including aggregating boolean fields, computing daily and average visibility rates, and applying date-based filters and conditional logic.
Coding questions · Amazon
Identify SQL Joins and Correct Query Errors
This question evaluates relational database fundamentals including the role of primary keys, SQL join types, set operations (UNION vs UNION ALL), date functions, and the ability to debug and correct SQL query syntax, reflecting both conceptual understanding and practical query-writing skills.
Coding questions · Meta
Identify Top 10 Users by Average Call Duration
This question evaluates SQL-based data manipulation and time-series aggregation skills, specifically computing per-user metrics from timestamped event data such as call durations.
Coding questions · Atlassian
Identify Top-3 Users by Recent Total Spend
This question evaluates SQL data manipulation competencies such as aggregation, joins, time-based filtering, and ranking to compute recent user spending; it falls under the Data Manipulation (SQL/Python) domain and targets practical application.
Coding questions · Amazon
Identify Top-Buying Customers Daily with SQL Query
This question evaluates a candidate's competency in SQL data manipulation, including aggregation over calendar dates, grouping by customer, and handling ties when determining top buyers.
Coding questions · LinkedIn
Identify Top Contributors by Recent Post Count
This question evaluates proficiency in SQL data aggregation and time-based event summarization, focusing on counting and grouping user-generated records to measure recent activity.
Coding questions · TikTok
Identify Top Discounts and Monitor Code Submissions
This question evaluates proficiency in data manipulation and aggregation concepts, including grouped summaries, tie-breaking selection among rows, and conditional counting across relational records using SQL or equivalent Python data tools.