READ. UNDERSTAND. PRACTICE.
Coding questions
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
1,899 resources · Page 40 of 80
Coding questions · Meta
Find top 3 books by total borrowed time
This question evaluates proficiency in data manipulation and aggregation using SQL or Python, covering joins, date arithmetic and null handling, grouping with distinct-count constraints, and top-N ordering with tie-breakers.
Coding questions · Amazon
Find Top-3 Salaries Per Department Using SQL
This question evaluates SQL data manipulation competency, focusing on group-wise aggregation, ordering, and selecting the top-N salary values within each department.
Coding questions · Databricks
Find top-5 most similar rows across datasets
This Coding & Algorithms problem in the Data Science domain evaluates similarity search and ranking skills, including selection and application of distance metrics (e.g., MSE, RMSE, cosine or Manhattan), handling of NULLs, feature scaling/weighting, and efficient top‑k retrieval across datasets.
Coding questions · Moloco
Find top advertisers and cost per KPI
This question evaluates proficiency in data manipulation and analytical SQL/Python skills, including aggregation, ranking with ties, dataset joins at a defined grain, date-based filtering relative to campaign launch dates, and handling division-by-zero scenarios when computing cost metrics.
Coding questions · Pinterest
Find top category by video time spent
This question evaluates proficiency in pandas-based data manipulation and aggregation, testing competencies in data cleaning, normalization, mapping, filtering, and computing summary statistics.
Coding questions · Capital One
Find top category per region in Aug 2025
This question evaluates proficiency in SQL data manipulation skills such as joining related tables, aggregating revenue, filtering by date and status, and implementing deterministic tie-breaking for categories.
Coding questions · Snapchat
Find top co-purchased products
This question evaluates algorithmic problem-solving and data engineering skills, focusing on computing and ranking co-occurrence frequencies, choosing efficient data structures for pairwise counts, and contrasting offline batch implementation with streaming updates.
Coding questions · eBay
Find top co-viewed products
This question evaluates algorithmic problem-solving and implementation skills in the Coding & Algorithms domain, including frequency aggregation, ordering with tie-breakers, and efficient data-structure use for session-based recommendation counting.
Coding questions · LinkedIn
Find top countries by population per continent
This question evaluates data manipulation competency in SQL/Python, specifically testing aggregation, ranking, deterministic tie-breaking, and percentage calculations across grouped data to identify top countries by population per continent.
Coding questions · NVIDIA
Find Top K Frequent Elements
This question evaluates a candidate's proficiency with frequency counting, selection techniques, use of appropriate data structures, and algorithmic time and space complexity analysis.
Coding questions · Meta
Find top-K frequent values with tiebreaks
Given an integer array and k, return the k highest-frequency values, breaking ties by smaller numeric value then earlier first-occurrence index (lexicographically for strings), and returning all uniques when k is too large. The solution covers an O(n) bucket-counting algorithm plus O(n log k) heap and expected-linear quickselect alternatives with their trade-offs, derives floor((sqrt(8n+1)-1)/2) as the maximum number of distinct frequency values, and outlines input validation for robustness at scale.
Coding questions · TikTok
Find top-paid employee per department
This question evaluates a candidate's competency in SQL data manipulation, including aggregation, ranking, handling of duplicate and historical rows, tie semantics, and temporal data interpretation when determining the top-paid employee per department.
Coding questions · ByteDance
Find top-paid employee per department
This question evaluates proficiency in data manipulation and SQL querying, testing concepts such as selecting the latest records, group-wise aggregation for top-N per group, handling duplicates and salary history, and deterministic tie-breaking when an employee appears in multiple departments.
Coding questions · Amazon
Find top-spend categories per customer with ranking
This question evaluates proficiency with SQL aggregation and JOINs, analytic/window functions (RANK()), tie and NULL/edge-case handling, and percent-of-total calculations for per-customer spend analysis.
Coding questions · Amazon
Find Top Three Books by City in Recent Months
This question evaluates proficiency in time-windowed aggregation, group-level ranking and window-function usage on relational datasets, emphasizing handling of recent date ranges and top-N selection.
Coding questions · Pinterest
Find top video category by average time
This question evaluates a candidate's ability to perform data manipulation and aggregation in Python (pandas), covering skills such as filtering, handling nulls and nonpositive values, mapping categorical IDs to names, rounding numerical results, and applying tie-breaking rules.
Coding questions · Snowflake
Find Tree Height After Deleting Nodes and Promoting Children
Compute tree height after deleting nodes while promoting their children, preserving descendants and counting retained nodes without rebuilding the tree.
Coding questions · Microsoft
Find Unique Zero-Sum Triplets
Find unique zero-sum triplets with distinct indices, deterministic ordering, careful duplicate suppression, and explicit time and space analysis.
Coding questions · LinkedIn
Find Users with at Least One Session Within a Duration Limit
Process chronological sign-in and sign-out logs to find users with any completed session at or below a maximum duration.
Coding questions · Oracle
Find users with at least one valid session
This question evaluates the ability to parse and process event logs, pair signin/signout events per user, and handle unordered timestamps and per-user state with time-window constraints.
Coding questions · Airbnb
Find Users with Seven Consecutive Impression Days
Find users with impressions on seven consecutive calendar days using PostgreSQL, accounting for duplicate days and longer activity streaks.
Coding questions · Amazon
Find Valid IP Addresses in Files
This question evaluates file system traversal, recursive I/O handling, text parsing and pattern recognition, input validation for IPv4 formatting, deduplication, and ordered output; it is in the Coding & Algorithms category and emphasizes practical application over purely conceptual understanding.
Coding questions · IXL Learning
Find value on most distinct levels
This question evaluates a candidate's understanding of binary tree structures, level-wise aggregation and frequency analysis, along with algorithm design and complexity reasoning.
Coding questions · Meta
Find Values Owned Only by the Selected User
Use PostgreSQL to find values belonging to one selected user and no other user, while handling repeated values and shared ownership.