Coding questions

1,899 resources · Page 3 of 80

1. Coding questions · Meta

   Analyze Top Call Initiators and Active French Video Callers

   This question evaluates proficiency in SQL-based data manipulation and analytics—specifically aggregation, grouping, time-window filtering, and percentage calculations—by asking for the top call initiators over the last seven days and the proportion of active users in France on video calls yesterday, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role with a focus on practical application. It is commonly asked in technical interviews to assess a data scientist's ability to extract actionable engagement metrics from event logs, reason about temporal windows and population denominators, and produce accurate, explainable reporting from production-style datasets.

2. Coding questions · Robinhood

   Analyze Transaction Flow and User Engagement Efficiently

   This question evaluates proficiency in SQL joins, aggregations and window functions alongside Python data-manipulation skills to compute per-user totals, running cumulative amounts, and leaderboards of senders and receivers.

3. Coding questions · PayPal

   Analyze Transactions and Classify by Amount in SQL

   This question evaluates SQL data manipulation competencies, including aggregation, grouping vs HAVING for filtered aggregations, and conditional classification using CASE WHEN on transactional data.

4. Coding questions · Apple

   Analyze TSV File for User Page Visits and Patterns

   This question evaluates skills in parsing and manipulating time-series user-event data, performing aggregations and path-frequency analysis, and understanding vectorized or parallel computations for performance.

5. Coding questions · Meta

   Analyze User Engagement and Spammer Read-Rate in SQL

   This question evaluates SQL-based data manipulation and analytics skills—specifically joins, time-window filtering, aggregation, and metric calculation for measuring user engagement and spammer read-rate—within the Data Manipulation (SQL/Python) domain.

6. Coding questions · Meta

   Analyze User Engagement Metrics for Video-Calling App

   This question evaluates competency in data manipulation and product-metric computation, focusing on combining user profile and call event data to produce user-level engagement measures like participation rates and average call duration.

7. Coding questions · Amazon

   Analyze User Engagement with SQL Queries

   This question evaluates proficiency in SQL data manipulation, including aggregation, window functions, joins, and temporal calculations for analyzing event and session logs.

8. Coding questions · Uber

   Analyze User Purchase Behavior in Online Marketplace Data

   This question evaluates data manipulation and analytical skills in SQL and Python, focusing on time-based aggregation, deduplication and ranking of events, calculation of rolling averages, and computation of daily active user metrics.

9. Coding questions · Meta

   Analyze VR App Usage and Engagement Metrics

   This question evaluates data manipulation and analytical competencies, including SQL/Python joins and aggregations, time-window filtering, definition of engagement metrics, and basic statistical hypothesis testing.

10. Coding questions · Others

    Answer ancestor-walk queries on a rooted tree

    This question evaluates understanding of tree data structures and ancestor-walk queries, assessing competency in traversing rooted trees, interpreting parent arrays, and designing efficient query-processing methods for large n and q.

11. Coding questions · Meta

    Answer four string/array/battery coding questions

    This set of four problems evaluates algorithmic competencies including ASCII string processing and character classification, array transformation and operation-count reasoning, cost-minimization for enforcing monotonicity under only-increase constraints, and time-based simulation of resource scheduling with recharge cycles.

12. Coding questions · Bloomberg

    Answer multi-round grid and data-structure questions

    This multi-part question evaluates algorithmic problem-solving and data structure design skills across ordered-array search with dynamic updates, expected O(1) randomized set operations, nesting-depth string parsing, Manhattan-range counting on grids, and constrained shortest-path search.

13. Coding questions · Meta

    Answer Repeated Range Aggregate Queries on a Static BST

    Preprocess a sorted array derived from a static BST to answer many inclusive range queries. Use binary-search boundaries and wide prefix sums to return both the sum and count for each range without rescanning the tree.

14. Coding questions · Uber

    Answer Repeated Shortest Increasing-Path Queries

    Preprocess shortest strictly increasing grid paths for repeated target queries, with deterministic BFS ties, predecessor reconstruction, and memory trade-offs.

15. Coding questions · LinkedIn

    Answer Repeated Shortest Word Distance Queries

    Preprocess a fixed word array and answer many shortest-distance queries between distinct repeated words. The prompt defines case-sensitive matching, ordered batch outputs, repeated queries, valid-word guarantees, and input sizes that reward indexed occurrence lists and two-pointer scans.

16. Coding questions · Akuna Capital

    Answer SQL MCQs with reasoning

    This question evaluates proficiency in SQL query semantics and reasoning about relational operations—specifically INNER, LEFT, and RIGHT JOIN behavior; GROUP BY and HAVING usage; NULL handling in comparisons and aggregates; window functions such as ROW_NUMBER and RANK; and the logical query processing order—within the Data Manipulation (SQL/Python) domain. It is commonly asked to assess the ability to interpret and justify query outcomes versus alternative answers, testing both conceptual understanding of relational theory and practical application of SQL query behavior.

17. Coding questions · Amazon

    Append country tables and rank salaries in USD

    This question evaluates skills in data manipulation and integration, specifically appending country-level tables, normalizing salaries via historical exchange rates, deduplicating by a composite primary key, and ranking results, with implementations expected in both SQL and pandas.

18. Coding questions · Anthropic

    Apply bitwise tricks for performance

    This question evaluates proficiency with bitwise operations, branchless programming, low-level performance optimizations, and microarchitectural reasoning about pipeline stalls, instruction-level parallelism, and cache behavior.

19. Coding questions · Capital One

    Apply commands to transform a matrix

    This question evaluates array and matrix manipulation skills, specifically in-place row reversal, row swapping, and 90-degree rotation, and falls under the Coding & Algorithms domain with emphasis on practical implementation.

20. Coding questions · Palantir

    Apply Item Coupons with Exact Per-Item Cent Rounding

    Calculate cart totals from item coupons with exact half-even cent rounding, unmatched-coupon handling, and integer monetary totals.

21. Coding questions · NVIDIA

    Apply sliding window techniques

    This interview question evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer for Apply sliding window techniques states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

22. Coding questions · Toma

    Approximate Pi from Random Points

    This question evaluates a candidate's understanding of Monte Carlo estimation, basic Euclidean geometry, probability, and numerical reasoning when using random sampling to approximate mathematical constants.

23. Coding questions · LinkedIn

    Arrange Nonnegative Integers to Form the Largest Number

    Arrange nonnegative integers so their decimal strings form the largest possible concatenation. The prompt requires every value exactly once, returns a string for unbounded result length, defines the all-zero case, and includes order-sensitive examples.

24. Coding questions · Microsoft

    Assemble DNA payload strings from tagged fragments

    This question evaluates proficiency in string manipulation, sequence assembly, and labeled-graph path reconstruction—skills involved in ordering fragments by matching start/end tags and concatenating payloads—and it belongs to the Coding & Algorithms domain.