Coding questions

1,899 resources · Page 63 of 80

1. Coding questions · Meta

   Query carpool ride metrics

   This question evaluates proficiency in data manipulation and analytical querying using SQL and Python to compute ride-sharing metrics such as daily completed pooled rides, average seats utilized, and cancellation rate.

2. Coding questions

   Query conversion and retention with SQL windows

   This question evaluates proficiency in SQL data manipulation—specifically window functions, event de-duplication, self-joins, date-windowed aggregation, and conversion/retention metric calculation—and is targeted at Data Scientist roles in the Data Manipulation (SQL/Python) domain.

3. Coding questions · Microsoft

   Query email logs for deliverability insights

   This question evaluates SQL-based data manipulation skills focused on event-time analytics, time-windowed aggregations, temporal joins, handling missing or multiple event rows, and computing deliverability metrics; it is categorized under Data Manipulation (SQL/Python) for a Data Scientist role.

4. Coding questions · Snowflake

   Query seven-day conversion with windows and dedupe

   This question evaluates proficiency in time-windowed aggregations, event deduplication, and window-function–based user-level analytics across SQL and Pandas workflows.

5. Coding questions · Boston Consulting Group

   Query top spenders and 7-day growth

   This question evaluates proficiency in SQL data manipulation, including aggregations, date-range filtering, joins, window functions for ranking and tie-breaking, and computing revenue shares and growth rates within a relational schema.

6. Coding questions · Roblox

   Randomly partition array into k segments

   This question evaluates algorithm design, randomization techniques, and time/space complexity analysis within the Coding & Algorithms domain, focusing on partitioning an array into random non-empty segments.

7. Coding questions · Meta

   Rank Ads by Conversion Rate for Top 10 Performers

   This question evaluates data manipulation and analytics skills for computing time-windowed ad performance metrics, including aggregations of impressions and revenue, join logic between impression and conversion records, conversion-rate calculation, and ranking.

8. Coding questions · Agoda

   Rank Customers by Monthly Revenue with Competition Ties

   Aggregate customer revenue by month and return top competition ranks, preserving tied totals and deterministic display order.

9. Coding questions · Atlassian

   Rank each team’s top 3 scores in 2024

   This question evaluates data manipulation and relational-query competencies, focusing on per-entity ranking, deterministic tie-breaking, and reshaping game-level records into team-centric perspectives.

10. Coding questions · Glean

    Rank Every Cell of a Distinct-Value Matrix Consistently Within Its Row and Column

    Replace every value in a matrix of distinct integers with the smallest rank such that larger values outrank smaller ones within each row and column. Tests processing values in sorted order, tracking per-row and per-column state, and the one-dimensional special case.

11. Coding questions · Oracle

    Rearrange an Integer Array into Its Next Lexicographic Arrangement

    A coding problem that asks you to rearrange an integer array into the next lexicographically greater arrangement of its values, wrapping around to ascending order when the array is already the largest. It tests reasoning about lexicographic order, repeated values and complexity analysis.

12. Coding questions · StackAdapt

    Rebuild a Binary Tree From Preorder and Inorder Sequences, Returned in Level Order

    Reconstruct a binary tree with distinct values from its preorder and inorder traversals and return it in level-order form with null markers. Tests how the two traversal orders pin down structure, careful index bookkeeping, and efficient handling of deep, skewed trees.

13. Coding questions · Meta

    Recommend friends-of-friends

    The question evaluates competency in graph traversal, set operations, and adjacency-list manipulation for social-network style data. Commonly asked in Coding & Algorithms interviews for Data Engineer roles, it gauges the ability to reason about relationship aggregation, duplicate elimination, and algorithmic efficiency when computing friends-of-friends, representing a practical application of algorithmic and data-structure knowledge rather than a purely conceptual exercise.

14. Coding questions · Coinbase

    Recommend movies by shared ratings

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

15. Coding questions · Meta

    Recommend two-hop follows in Python

    This question evaluates fluency with graph traversal, set operations, deduplication, and frequency-based ranking in Python, targeting manipulation of directed "follows" relationships represented as dictionaries and is categorized under Data Manipulation (SQL/Python).

16. Coding questions · Capital One

    Reconcile ledgers with SQL/Python and late events

    This question evaluates a candidate's ability to implement data reconciliation and ETL engineering skills, including SQL window functions and joins, time-based FX rate lookups, matching logic for late-arriving events, idempotent daily pipeline design with deterministic keys and exactly-once semantics, and basic statistical charting in Python.

17. Coding questions · Stripe

    Reconcile Monthly Bank-Account Balances Across Two Datasets

    Compare bank-account balances for a target calendar month, report match status, and distinguish missing comparison records from zero balances.

18. Coding questions · TikTok

    Reconstruct a tree from two traversals

    Reconstruct a tree from two traversals evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

19. Coding questions · NVIDIA

    Reconstruct tree from inorder and postorder

    This question evaluates understanding of binary tree traversal relationships, recursive construction techniques, and algorithmic time and space complexity, reflecting core data structures and recursion competencies.

20. Coding questions · Microsoft

    Recover Sorted Digits from Scrambled English Number Words

    Recover sorted digits from scrambled English number-word letters, including repeats, and analyze why arbitrary customer vocabularies may lose unique recoverability.

21. Coding questions · Airbnb

    Redact Document Phrases with Simultaneous Replacement

    Redact document phrases with a replacement map, whole-word matching, longest-match overlap rules, and one-pass replacement of original text.

22. Coding questions · Databricks

    Referral Credit Tracker with Indirect Referrals

    Build a referral credit tracker with account creation, threshold queries, deterministic ordering, and correct credit propagation through indirect referrals.

23. Coding questions · Meta

    Remove adjacent duplicate groups repeatedly

    Remove adjacent duplicate groups repeatedly evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

24. Coding questions · Salesforce

    Remove duplicates from a singly linked list

    This question evaluates understanding of singly linked list data structures and in-place node manipulation to remove repeated values while preserving relative order, testing competencies in pointer management and duplicate-detection.