Coding questions

1,899 resources · Page 18 of 80

1. Coding questions · Meta

   Compute unconnected 60s posts and reactions averages

   This question evaluates data manipulation skills in SQL and Python, focusing on deduplication, join logic between event and reaction tables, date handling for string-typed dates, and aggregation to compute per-post metrics.

2. Coding questions · Nuro

   Compute unique duration by merging intervals

   This question evaluates a data engineer's proficiency in temporal data manipulation and interval-set reasoning using SQL and Python, specifically skills in merging overlapping intervals and computing deduplicated cumulative durations.

3. Coding questions · Amazon

   Compute unique visitors by department

   This question evaluates proficiency in SQL data manipulation, specifically JOIN operations between event and product tables, deduplicating distinct users, applying time-range filters, and reasoning about hierarchical product attributes (department/category/subcategory).

4. Coding questions · Meta

   Compute unread and multi-account user percentages

   This question evaluates understanding of SQL data manipulation skills such as aggregations, joins, NULL handling, deduplication reasoning, and user- versus person-level computations for accurate percentage metrics.

5. Coding questions · Snapchat

   Compute User Group Stories and Aggregate Story Engagement

   This question evaluates data wrangling and aggregation competency in pandas, focusing on group-level aggregation and filtering of engagement metrics across users and story types.

6. Coding questions · Snapchat

   Compute User Retention and Analyze Event Data

   This question evaluates a candidate's ability to perform SQL and Python data manipulation for event analytics, including cohort retention, aggregation of distinct purchasing users, median-of-daily-events calculations, and hourly time-series grouping.

7. Coding questions · PayPal

   Compute Variance from a Python List

   This question evaluates understanding of basic statistical concepts and numerical computation—specifically population versus sample variance—and tests algorithmic implementation skills, edge-case handling, and complexity reasoning within the Coding & Algorithms domain.

8. Coding questions · PayPal

   Compute variance of a list in Python

   This question evaluates understanding of statistical measures and numeric computation, focusing on implementing variance calculations (population vs sample) and considerations for numerical stability.

9. Coding questions · Meta

   Compute vertical order of a BST

   This question evaluates understanding of binary tree traversals and coordinate-based ordering, including tie-breaking by breadth-first visitation order, plus competency in algorithmic time and space complexity analysis and strategies for handling deep recursion and streaming large inputs.

10. Coding questions · Meta

    Compute video-call SQL metrics with edge cases

    This question evaluates the ability to manipulate time-series and relational call/event data using SQL (and optionally Python), emphasizing aggregation, DISTINCT counting, interval-overlap logic, and handling edge cases such as duplicates, failed calls, users joining multiple times, calls spanning midnight, and test accounts.

11. Coding questions · TikTok

    Compute waits and find distance-k node pairs

    This question evaluates proficiency in algorithm design and data structure usage for both array and tree problems and falls under the Coding & Algorithms domain; it is commonly asked to assess algorithmic thinking, time and space complexity reasoning, and robustness in handling edge cases.

12. Coding questions · Paradromics

    Compute ways to climb n steps

    This Coding & Algorithms question evaluates recursion and dynamic programming concepts by asking for the count of distinct ways to climb n steps, framed at an algorithmic/implementation level. It is commonly asked because it probes recognition of overlapping subproblems and the ability to optimize naive recursive approaches through subproblem reuse and improved time/space efficiency.

13. Coding questions · Thumbtack

    Compute weekly 3-week rolling sums in SQL

    This question evaluates time zone–aware date bucketing, gapless calendar generation, and rolling-window aggregation skills, demonstrating competency in SQL-based data manipulation and temporal reasoning.

14. Coding questions · Thumbtack

    Compute weighted response rates by job category

    This question evaluates a candidate's data manipulation and statistical estimation skills, including pandas-based aggregation, invitation-weighted rate calculation, confidence-interval computation, and robust handling of data-quality issues, in the Data Manipulation (SQL/Python) domain.

15. Coding questions · Meta

    Compute weighted sum of nested lists

    This interview question evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer for Compute weighted sum of nested lists states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

16. Coding questions · TikTok

    Compute widest level span in a binary tree

    This question evaluates understanding of binary tree traversal, positional indexing in a complete binary tree, and handling integer overflow while computing level widths.

17. Coding questions · Morgan Stanley

    Compute win probability in coin-toss game

    This question evaluates understanding of probability theory and stochastic processes, focusing on win probability in an alternating coin-toss game and reasoning about pattern occurrence and stopping times in random sequences.

18. Coding questions · Dropbox

    Compute worst-case guesses for adaptive hangman

    This question evaluates algorithmic problem-solving, combinatorial reasoning, and adversarial information-theoretic thinking by requiring modeling of worst-case query strategies for adaptive letter-guessing.

19. Coding questions · Meta

    Connect next pointers for each tree level

    Evaluates understanding of binary tree traversal, in-place pointer manipulation, and time-space trade-offs by requiring population of sibling pointers across each level while meeting O(n) time and O(1) extra space constraints.

20. Coding questions · Amazon

    Consolidate and Rank Global Salaries in USD

    This question evaluates data consolidation, currency normalization, and ranking competencies, measuring the ability to combine country-specific employee data and convert salaries into a common USD basis within the Data Manipulation (SQL/Python) domain.

21. Coding questions · Meta

    Construct a BST and read spiral order

    This question evaluates proficiency in data structures and algorithm design by testing binary search tree reconstruction from a preorder sequence and matrix spiral (clockwise layer) traversal.

22. Coding questions

    Continue Entry Numbers for a Daily Incremental Batch

    Continue per-context entry numbering for a daily batch using stored maximums, ordered row numbers, and correct new-context handling.

23. Coding questions · Meta

    Convert 32-bit integer to hexadecimal

    This question evaluates understanding of integer representation, hexadecimal notation, bitwise operations, and 32-bit two's complement arithmetic. It is commonly asked to assess low-level data representation and edge-case handling within the Coding & Algorithms domain, and it tests practical implementation skills alongside conceptual understanding of binary and base conversion.

24. Coding questions · Houzz

    Convert a Column Number to an Excel-Style Label

    Convert one-based spreadsheet columns into A-through-Z and AA-through-ZZ labels, with correct handling of multiples of 26.