cswork / libraryOpen practice workspace

READ. UNDERSTAND. PRACTICE.

Coding questions

Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.

1,899 resources · Page 44 of 80

  1. Coding questions · Amazon

    Identify Top Spenders and Segment Customers Using Python

    This question evaluates proficiency in data manipulation and aggregation using SQL/Python (pandas), covering customer segmentation, monthly grouping and ranking, and reshaping transactional data into a wide format for product-level spend analysis.

  2. Coding questions · Meta

    Identify Top Three Active Users by Event Date

    This question evaluates proficiency in SQL-based data aggregation and ranking techniques applied to event logs, testing skills such as grouping, counting, and the use of window/ranking functions to identify top users by date.

  3. Coding questions · Robinhood

    Identify Top Users with Declined Transactions in SQL

    This question evaluates proficiency in SQL data manipulation, specifically aggregation, window functions, rolling 24-hour time-window analytics, NULL handling, and conditional classification via CASE WHEN within a fraud/risk detection scenario.

  4. Coding questions · Robinhood

    Identify Transactions During 'Golden' Membership Period

    This question evaluates proficiency in temporal data manipulation and aggregation, covering SQL date-range joins, window functions for per-user ranking, and Python frequency counting of senders and receivers, and it falls under the Data Manipulation (SQL/Python) domain for data scientist roles.

  5. Coding questions · Meta

    Identify Unique Callers and French Customer Call Percentage

    This question evaluates proficiency in data manipulation, specifically aggregation and deduplication of user activity, time-based filtering of recent events, and computation of proportions using SQL or Python.

  6. Coding questions · Amazon

    Identify Unique Unordered City Pairs in Flight Log

    This question evaluates competency in data manipulation, deduplication of symmetric relationships, and handling unordered pairs within relational or tabular datasets using SQL or Python/Pandas.

  7. Coding questions · Meta

    Identify Users Interested in Group Video Calls

    This question evaluates a data scientist's ability to perform SQL-based event-level data manipulation, aggregation, joins, and user-level feature derivation from call logs and user attribute tables.

  8. Coding questions · PayPal

    Identify Users with Specific Page Navigation Patterns

    This question evaluates a data scientist's competency in SQL-based sequence detection, temporal filtering, and aggregation to identify repeated navigation patterns within user-day sessions.

  9. Coding questions · PayPal

    Identify Users with Specific Page Visit Sequence

    This question evaluates event-sequence detection and temporal ordering skills in SQL, focusing on concepts such as windowing, adjacent-row reasoning, and session-scoped grouping to identify ordered page visits.

  10. Coding questions · Amazon

    Illustrate SQL Join Results with Duplicate Keys

    This question evaluates understanding of SQL join semantics and the effect of duplicate key values on result cardinality, assessing competency in relational data manipulation and reasoning about result sets.

  11. Coding questions · Glean

    Implement 2048 tilt move

    This question evaluates a candidate's ability to implement array and matrix manipulation, deterministic state-transition logic, and rule-based merging behavior in a grid-based simulation.

  12. Coding questions · NVIDIA

    Implement 2D convolution using NumPy slicing

    This question evaluates a candidate's proficiency with array manipulation and vectorized numerical computation using NumPy, focusing on 2D convolution concepts such as slicing, broadcasting, and filter application.

  13. Coding questions · Capital One

    Implement 2D transforms and find max-lit point

    This question evaluates array-manipulation and interval-analysis skills, specifically in-place 2D matrix transformations (row/column swaps, reversals, rotations) and determining the point with maximum overlap among one-dimensional illumination intervals.

  14. Coding questions · Uber

    Implement 2D word search variants and analyze complexity

    This question evaluates proficiency in grid-based string search, traversal techniques (fixed-direction scanning versus flexible-path exploration), algorithm design including backtracking/DFS, and the ability to analyze time and space complexity while accounting for redundancy and edge cases.

  15. Coding questions · Salesforce

    Implement 64-bit modular exponentiation safely

    This question evaluates proficiency in modular arithmetic, safe 64‑bit integer operations, and algorithmic techniques for overflow‑resistant modular multiplication and exponentiation.

  16. Coding questions · Anthropic

    Implement a Banking System

    This question evaluates skills in designing and implementing a stateful in-memory banking system, covering account modeling, transfer lifecycle and expiration handling, balance management, and tracking aggregate outgoing amounts.

  17. Coding questions · Sigmacomputing

    Implement a basic pivot table with totals

    This question evaluates a candidate's ability to perform in-memory data aggregation, multi-dimensional grouping, handling missing combinations, and formatted text output for pivot tables including row/column totals.

  18. Coding questions · Hebbia

    Implement a Cache Snapshot Printer

    This question evaluates understanding of LRU cache semantics, data structures for maintaining recency and eviction, and techniques for serializing or compressing state by grouping identical values while preserving ordering.

  19. Coding questions · DoorDash

    Implement a consistent hashing ring

    This question evaluates understanding of consistent hashing, virtual nodes, deterministic hash functions, and data structure design for efficient key-to-server mapping and dynamic membership changes.

  20. Coding questions · Chicago Trading Company

    Implement a Constant-Time Simple Moving Average

    Implement a fixed-window simple moving average with O(1) processing for every valid add and query. Maintain a rolling sum and bounded queue, average the samples available before the window fills, and return deterministic results for empty, malformed, or unknown operations.

  21. Coding questions · Anthropic

    Implement a crash-resilient LRU cache

    This question evaluates knowledge of cache design, least-recently-used (LRU) eviction policies, deterministic memoization key construction for function identity and arguments, and persistence mechanisms for crash resilience in the Coding & Algorithms domain.

  22. Coding questions · Coinbase

    Implement a crypto order management system

    This question evaluates data-structure design, command parsing, state-management, and error-handling competency for implementing an in-memory order management system, and is categorized under Coding & Algorithms with a practical application focus emphasizing efficient query support.

  23. Coding questions · Scale AI

    Implement a Dependency-Aware Task Scheduler

    This question evaluates skills in dependency management, deadline-driven scheduling and algorithmic data-structure design, focusing on handling directed acyclic graphs and ordering constraints.

  24. Coding questions · Applied Intuition

    Implement a Fixed-Capacity Deque

    This question evaluates proficiency with double-ended queue semantics, fixed-capacity data structure design, constant-time (O(1)) operations, and correct handling of boundary conditions and wraparound.